I have a Smartsheet for each fiscal year, and will continue to add new sheets for each FY. On a separate sheet, I want to find the sum of values that appears in all of the FY sheets. For example, if I want to sum the total amount an employee makes on my Summary Sheet, referencing data on multiple FY sheets, I know I can…
I'm new to SS. This is my first project. I have an audit process I am building for a customer. There are 5 separate forms needed for the audit process. I originally had all 5 forms feeding the same sheet but with over 100+ columns for each audit, I went crazy scrolling left to right looking for the information I needed and…
I use a form to help my team record a log of completed work but I have an issue with recording the date. There's a date field on the sheet and I've added it to the form but I want it to default to today's date (whatever that may be when someone uses the form) and I can't find a way to do so. I can set a default value in…
Is there a way to have all the Notification & Sharing Options checkboxes when saving as new? Is there a setting that can be 'turned on' to do this?
I have added a column to put in the number of hours I would expect the task to take each day. I prefer this to having to work in percentages of a day and think this will be easier to request of my team. To allow this I need to put a formula in Resource % Allocation column to divide the number of hours by the number of…
Hello, I'm trying to setup a "Line Quantity" of children where the primary column contains a 5 digit number. These numbers indicate line items of a purchase order and have a hierarchy themselves. The numbers that are considered the parent end in 000 with all the items that are children end in various numbers in increments…
I'm looking to connect with anyone using smartsheet for tracking recruiting conversion metrics! My team currently uses sheets for tracking all candidate submittals and feedback between recruiters/HMs. Has anyone created a report or sheet to track the funnel conversion metrics from submission to hire?
I created a workflow. The screen shot is attached. I was trying to see if when ready for approval is checked can approval status automatically change to submitted? How is that done if possible?
I am using curl with REST to access Smartshets in my C# running on WIN CE. My application is supposed to dump some data on smartsheet periodically. Before I write to a sheet, I would like to know the total row count in the sheet so that I don't exceed 5000 rows per sheet. I am looking for an API that would return just row…
Hi Smart Sheet Community! I am applying a formula to a cell in our project schedule sheets that I found in a couple posts to grab the MAX value of the Modified (Date) column: =MAX(Modified:Modified) + "" My colleagues and I will be linking the cell with this formula from our project schedule sheets to a "Last Updated"…