I'm trying to set up a formula that looks at one cell to see if there is a date in it. If there is a date, I want show the date but if there isn't a date, I want it to say "not set up yet."
@Missy Folkemer You should be able to use the formula "isdate"
=if(isdate(date@row), date@row, "Not Set Up Yet")
What am I missing? =IF(ISDATE([Start Date]460, [Start Date]460), "Not set up"))
It is saying unparseable.
@Missy Folkemer you just have a parenthesis in the wrong place.
Also, unless you are looking at a specific row, your formula should be
=IF(ISDATE([Start Date]@row), [Start Date]@row, "Not set up")
This gave me an invalid column name. I am looking at a specific row. I have it like this now but this is what is giving the current invalid column error.
=IF(ISDATE([Start Date]130), [Start Date]130, "Not set up")
nvm I found the problem, it was in the column property. Thank you!
I've been trying to do a simple check of whether or not the entry from the form has a returned value that is either yes or no and it checks 3 cell locations to see if any returned yes. The 3 columns are Dropdown lists for Yes/No and the Status is a Text/Number, is that the issues? If not how do i fix that?
I'm wondering if there is a way to lock rows 1-12 out of the sorting and filtering of a sheet. I might have take out that part of the from otherwise I dont like how the built in dashboard moves when a sort or filter is applied?
Hello, I apologize if this has already been answered, I did search before asking. I recently downloaded a template and it had the google slides displayed in presentation mode. I cannot figure out how to do this as when I embed, it's just the entire google page where you can edit and see the menu bar. How do I embed the…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.