Hello Power Apps Community.
Can you help please?
I'm creating a Formula column where I want to count the number of data between the 'Created On' column when the 'Status Reason' changes to the value of 'Done'. It's numerical value is 100.
I imagine I can do this with a real time workflow or a Power Automate Flow, but wanted to try it with a formula column. Below is the formula that I'm having trouble with.
If('Status Reason' = 100,
DateDiff('Created On', 'Modified On'),
DateDiff('Created On', Now())
)
The error I'm getting is:
Incompatible types for comparison. These types can't be compared: OptionSetValue (publisher_transfertask_publisher_transfertask_statuscode), Decimal.
Any idea what I'm doing wrong, please?
Thanks,
Garry