I'm creating a project tracker where I can assign what phase the project is at (design, prototype and complete). What I want to do is track how long the project is in each phase, so what I plan on doi…
I have a smartsheet that has a column for "State" and then a column for "Territory". How do I write a function that if a row within column "State" equals say "TX" than the column for "Territory" withi…
Thank you for your time. I cant find the answer in the documentation or forum. So I am asking. a. How do I reference a single cell in an external sheet? b. Can I reference a cell by row number and col…
I want the time a specific cell is edited to be automatically placed in a cell. I don't want to use the column setting because that updates when any cell in the row updates and not just the one I want…
I am receiving an #INVALID DATA TYPE Error when I have blanks in the dates I am referencing. The formula is summing the equipment pieces based on the delivery month, but the delivery date can be added…
I know how to copy rows to another sheet when a criteria is met. But is there way to do only copy certain rows to the new sheet? I can do this via Zapier, but would love to be able to do it natively w…
Hi everyone, i recently uploaded a file from excel and linked it to an existing worksheet in smart sheet. The file in excel is updated every week. Is there a way i can synchronize the file with smart …
Looking for a consultant to help our business maximize how we currently use Smartsheet. Needing someone with expertise in offering opinions and solutions for our needs. We are wanting to revamp our pr…
Hi I have a sheet, and in it there's a VLOOKUP to another sheet. I set a Copy Row Automation so that when the vlookup cell is filled, it should Copy the Row. I setup the Wrokflow like this: Trigger: W…