Sign in to join the conversation:
Hello,
Looking for some formula help. I am using the formula below and need to figure out how to display the date the Status cell was changed instead of updating to today's date.
=IF([Status]1 = "Completed", TODAY())
Thanks for your help!
Andrea
Hi Andrea,
Unfortunately, it's not possible at the moment, but it's a great idea!
Please submit an Enhancement Request when you have a moment.
You could use the cell history or the Activity log, but it won't work in a formula.
Another option would be to use a third-party solution like Zapier or similar.
Would any of those options work?
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
Hi Andree,
Thank you for your fast reply!
I have submitted an Enhancement Request via the link provide above. We will look into these other options for solving our issue with this formula.
Have a great weekend!
Happy to help!
Andrée
I'm need to apply a function to average a column (answer is correct (8)) if the other column (The nurse is caring for a a patient who dove into a) is NOT blank. I copied this over from an excel spreadsheet. I would like to keep the average in the top row. Right now it's saying "#unparseable" as the formula is not the same…
This discussion was created from comments split from: How do I combine multiple INDEX Collect formulas in one Formular?.
So here is my current formula… =COUNTIFS({Date Completed}, IFERROR(MONTH(@cell ), 0) = MONTH(TODAY()), {Staff name}, =Staff@row ) This works. It gives me a number for all observations submitted in the month. The problem is it also counts the month for the previous year. How do i filter the count by month and year? Thank…
