-
Is there a way to capture the latest comment on a sheet?
In a project schedule sheet, where comments are made on rows/tasks, I want to grab the comment that was made last on that project sheet to use in a summary report. I know you can view all the sheet comments, but I only want to capture the last comment made on the sheet. Goal is that the summary sheet will always have that…
-
Override Contact List selection
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 sheet. Users access it via a Dynamic View. This all works well but there is a specific use case I haven't been able to deal…
-
CountIFs formula question
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 Location (A-C) have the value Properly demonstrated and Not Properly Demonstrated selected. This is currently the formula I…
-
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…
