Welcome!

Conditional Formula

What is the formula to use if I was to populate a value in one column if the Start date is today's date or later? Is this possible? So if the start date is todays date (for example) I would like the status column to change from a value of Planned to Current. Any ideas?

Find more posts tagged with

Comments

Andrée Starå

Hi,

Try something like this.

What do you want it to show if there isn't a date?

=IF(Date@row >= TODAY(); "Current"; "Planned")

The same version but with the below changes for your and others convenience.

=IF(Date@row >= TODAY(), "Current", "Planned")

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 day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Sign in to join the conversation!

Quick Links

Trending discussions

I am getting an error message when attempting to export to excel
I am attempted to export to excel. I have two different smartsheet documents to export. One of them exported to excel fine, but not the other. This happened a few weeks ago. I make sure all columns were the correct size & no cells were hidden. "We have found a problem with (file) Do you want us to try and recover as much…
Need Help w/ Report View - Nothing Is Showing
Hello Smartsheet Community, I need some help with a report that I created and shared with a customer. The customer is not seeing any of the information that is pulling into the report. See screen shot below that the customer texted me. I do have the report filter only showing the customer their product pulling from our…
How can I hard code a cell based on a trigger?
BLUF: When I create an Invoice, I need the cell-link to my live price data to be severed. I currently have a Price sheet for my products that is updated frequently. I use Control Center to create Projects, which includes an Invoice sheet. I have a dropdown on my invoice sheet to select a product, and then I use Index…