We have a list of software/hardware/contract obligations. Currently it is setup to provide 30, 60, and 90 day reminders (based on current the due date) to the interested parties so our contracts and l…
I'm building a Form, and one of the criteria is Budget. I would like to evaluate the Budget field as they tab-off of it, before the form is submitted as I know there would be times people will enter a…
Hello, I am relatively new to Smartsheets. I am trying to write the following formula but continue to hit an "UNPARSEABLE" Error. I am sure I am missing something but cannot find the issue. I would ap…
We run many projects using smartsheet, each project has a seperate sheet and always adding more. We would like a metric on a dashboard to show the number of x tasks due (i.e. shop drawings or site mea…
Hi, I wanted to know if its possible to have the entry number as the Function + RAID item(R,A,I,D) + number. What I am looking for is for the R,A,I,D items to be named as per the functions- i.e. if it…
I am trying to figure out a formula that will add 1 to the Parent [DMR #] The below will Place a "1" at the end but I need to add count by one Like this DMR5575-1 DMR5575-2 DMR5575-3 =IF(Level1 = 0, […
I am trying to have a report that shows only the lowest indented children in it. I am working on a sheet that has 4 level of indents. Workstream (indent 0), Project (indent 1), Milestone (indent 2) an…
Has anyone had any success with maneuvering around the fact that new parent rows created by a form and added to the bottom of a sheet will not inherit the formulas of the row above? Here's the note fr…
I have an approval workflow that is currently in use. I referenced and copied the workflow exactly but it is not working the same way. I have it set up so that when a cost is entered in, it sends an a…
