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!
I'm trying to create a formula that will output a Product category. Below is the formula and I've provided a screenshot of the columns involved. =IF(AND(Folder1 ="default", [Cost Category]1="Printer : Plex", ISNUMBER(FIND("Color",[Cost Option]1))), "Color Impressions", If(AND(Folder1="default", [Cost Category]1="Printer :…
Hi All, I have a project plan with a column called "Owner" that has a column type of contact list. The contacts are from multiple companies. It's a large project plan. I have created columns that have a column type of checkbox. I want to check the box if the owner is from a certain company (which can be determined by the…
Hello, I am trying to use JOIN-COLLECT to populate a cell with a contact by pulling from another sheet. However, when I use this formula it populates the cell with the name of the contact as a text string, but does not populate the cell with the contact itself. Both the column of cells being populated and the column the…
