This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
So I have a column titled “Days Since Update” which is the days since a certain date to today and then “Field 10” is based on an If Formula (if the status is completed it gives a 0).
I now want a formula column which gives the smallest of these two v...
That’s been so helpful- thank you!
I went with the second option which has worked really well. I only originally wanted it to show a 0 when the status is complete/no further action but this is so much better. Really appreciate all of your help
Thanks...
Hi Jonathan,
I’ve managed to crack it with:
IF(Status=‘Completed’,“Complete”, DATETIME_DIFF(TODAY(),{Last Update},‘d’))
However as well as ‘Completed’ i also have a status of ‘No further action’ how can I do include this as well? Can i do it with ano...
Hi Jonathan,
I think this would be absolutely perfect however my completed column is a single select field where I select ‘Completed’ how would I amend your formula to reflect this?
Really appreciate your help
