Sign in to join the conversation:
I cannot figure out why this formula doesn't work for me. I've tried a date instead of TODAY(), same results. Any help appreciated. Both columns are formatted for dates.
Try changing the Days under Load column properties to Number/Text.
I second Brian's suggestion. The #Date Expected error is indicating that that column type expects a date returned, not a number. Changing that to text/number column type should resolve the issue.
This is a great resource for troubleshooting errors: https://help.smartsheet.com/articles/2476176-formula-error-messages
I used to use this all the time. I've since written many an error into formulas, so now I only need to refer back to it occasionally. Haha
Thank you everyone, that worked. Super confusing. #DATE EXPECTED to me suggests the column should be formatted for date...
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…
I have an automated workflow set up to run weekly and request an update when the project is in certain statuses. The automation only ran once and now it's not working even though I have it set up to run weekly. I need help troubleshooting why this isn't working.
