Hello Smartsheet Community, I'm looking for some help in utilizing the OR statement within a function which references columns in another sheet. I am trying to count how many rows have a request statu…
I'm building out a plan with tasks and dependencies and want the dates to populate based off a vlookup. For example, If "Sprint 12" is selected then the proper start date is set in the Sprint Start Da…
Hello, I wish to have a Automatic Daily Report on Smartsheet but I didn't find a way to do that yet. I manage some resources and they are allocated in many projects at the same time. Many tasks have d…
We have implemented a Smartsheet that uses a vacation approval workflow. A form is used by an employee to request time off. Once the form is submitted, an entry is made in the Smartsheet and an approv…
Hi, I am trying to setup a "Stale" notification for a help ticketing system. When a support ticket (row) ticket has not been modified when compared to the current time and date in over an X amount of …
Hey there! I'm currently tracking our sales analytics using a smartsheet. Column A lists all of my metrics and then i create a column for each week. As the weeks progress, i fill in the rows with sale…
Everytime I add a new row in my sheet, I have to go in and make the formula go onto that new row. Is there a way to have the formula auto-populate whenever I add a new row into the sheet?
