-
Automate message to a contact on a separate sheet
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 Contact column and the department. Sometimes units have up to 3 managers for the same department. When the person in the first…
-
Submission checklist to reference production schedule
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 columns, Job #, Job Name, Line 2 Count, Submitted, Outstanding Entries, Missing Form Override(Checkbox), and Status The idea is…
-
Using Smartsheet Baselines values
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?
-
Row numbers
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 whenever I try to add a new row in between it calculates the row number from the bottom (WOW), this is very bad and this is…
-
Last 7 Days
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 as #UNPARSEABLE. =COUNTIFS({Filing Submitted Date}:{Filing Submitted Date}, {Filing Submitted Date}@cell>=TODAY(-7), {LRT…
-
Formula Assistance 🙏
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 write a formula for the wellness remaining column, but I have a rule I must follow that is giving me a headache for the…
-
Pull most recent entry based on date comparing two sheets
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 I'm writing the formula on. I need it to look at two sheets, an open work and a complete work. Both sheets have a created…
-
Creating Conditions that affect other rows
Hello, I am super new to smart sheets, but have done very well with 99% of what I have needed to accomplish, however… When trying to create a condition labeled "Yes | No," and if Yes is selected in that row, then I want it to highlight another row also in the primary column to red to highlight it being the next step to…
-
Convert VLOOKUP to INDEX/COLLECT?
Hi, I am trying to calculate the fees for a project based a list of fees from another sheet. My current formula works when only one product is selected but does not work for multiple products. Would converting this to INDEX/COLLECT work? And if so, how would I do it? Current formula looks up the value in Project Type/Scope…
-
Can I turn comma separated lists into multiple-choice dropdowns?
The title basically says it all. I have a column that was built in Excel, with multiple items separated by commas (no spaces) to make a string of about 1-5 items. We're moving our processes into Smartsheet, and I want this information to be formatted as a dropdown column with each item chosen as a separate entry.…