The formula value of [Duration]@row is a numeric value of 0 for both a Duration cell value of 0 and ~0. This means it is not possible to determine the number of work days that Smartsheet will then use…
I'm interested in running a Kickstarter campaign and haven't done one before... has anyone on here ever ran a campaign for a tangible product development project and tracked it in Smartsheet? Would yo…
I have the following columns that are linked to another smartsheet: Citrix Status - Network Status - PC Status - Phone Status - Completion Date When all columns have the "Complete" status, the Complet…
Hello, I have successfully established a formula link between two date columns (Start & Finish) and my 3 status trackers (Completed, In Progress, Not Started). The formula I have used successfully is:…
I am looking for a way to send multiple update requests in a single email. Here is the scenario. Once a product is inspected, I want to check a Smartsheet checkbox saying that it passed inspection. Th…
I'm not sure why my formula isn't working. I also wonder if I can do Today(-7) in the formula. I've seen +days but not -days so maybe that's the issue? If so, how do I write it such that if the finish…
Hello Forum, I am having difficulty writing a formula to count NETDAYS if a project status is "Complete". I hope this is not too confusing, but here goes..... 3 COLUMNS: "Project Status", "Actual Star…
Hi there, I'm trying to set up an IF formula to pull the Month from the "due date" row. I've been using the following formula: IF(MONTH(DATE@row) = 1, "January", IF(MONTH(DATE@row) = 2, "February"....…
Hello all, I have dug around enough to be certain that there is no feature to restrict a column to a certain data type (i.e. restricting a text/number column to only be 6 numeric digits). This is some…
Hello colleagues and guests. I would like to learn a forumula to retrieve a date that is exactly six months later than a known date; i.e. Jan 1 - July 1, Feb 4 - Aug 4. Presently, I'm using 182 days, …
