I have a sheet that collects content from a Form and includes some auto-filled columns and column formulas, but also automations to Move rows depending on the contents of other columns. I'm wondering …
I've developed a tracker that assigns a support person to a request for service. An INDEX/MATCH formula selects the appropriate person from one sheet and fills the contact list field in the request sh…
Hi, I am trying to count the amount of time a drop down is selected within a range of columns that is in a specific location (separate column with it's own values). My goal is to count how many times …
I have a complex sheet of information about people who finish a certification. This sheet includes their department. On a separate sheet, I"ve created a contact list of their managers including a Cont…
Good morning, I have 2 Sheets Master Production Schedule - consists of multiple columns, Job #, Job Name, Line 2 Count, Forms Submitted?, and Status Check List Submission - consists of multiple column…
Is there a way to use a helper Column and Formula to turn a Smartsheet Baseline variance into a real number so I can get an average? OR is there a better way to baseline changes to end dates?
Hi, I have seen multiple threads around this but still I'm surprised there is no dynamic solution for this, I have tried auto populating ROWID by AutoNumber column and as you can see in screenshot whe…
I need a formula that counts the number of requests that have been submitted within the last seven days if assigned to "John Doe". Smartsheet's AI generated this formula, however it comes back to me a…
I have the following data set: Wellness Annual Total Wellness Expense Wellness Remaining Education Annual Total Education Expense Education Remaining $1,000 $500 $500 $5,000 $4,500 $500 I am trying to…
Hello, I am having an issue writing out this fromula and needed some assistance. I need to write a formula that checks for an ID number titled MLL ID [ie. MLL00132] that is an auto number on the sheet…
