Sign in to join the conversation:
Hello,
I'm having trouble finalizing IF statement for the following:
If "Approved By" is NOT blank, the Date Approved = Today's Date
Thank you for the community support in advance.
Hi,
Try something like this.
=IF(ISBLANK([Approved By]@row); TODAY())
The same version but with the below changes for your and others convenience.
=IF(ISBLANK([Approved By]@row), TODAY())
Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.
Did it work?
Hope that helps!
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
=IF(NOT(ISBLANK([Approved By]@row)), TODAY())
worked for what I was looking for. Thank you for the support!
I missed the NOT part!
Glad you got it working!
Happy to help!
Hi community i'm trying to create a formula that calculate a sum in a column based on may criteria. here is a screenshot of the affected column i want to calculate the "volume cumul" (sum of volume collected) based on Week Active should be "This Week" or "Next Week" same Unique ID should be calculated together if Unique ID…
Hi I am trying to work out a percentage for some KPIs. I have a sheet I am recording various KPI entries on (see below) I have a metrics sheet set up so, I can break the KPI results down by month by referencing this sheet. Taking KPI 1 (in the example shown above), I need a formula that will return a percentage of the…
Hi all, Is it possible to display some sort of graphic like this within a dashboard? I'd be taking data from a form and gathering total numbers of of "yes" and "non" questions to get the numerator and denominator for each row or column in the picture. I think I could do the metric sheet part of this task no problem, but…
