-
NEW! Your survival guide to formulas is here. Meet the Formula Handbook.
Hi Community, Whether you’re summing child rows, calculating budget minus actual, or doing cross-sheet data lookups with multiple criteria, formulas are a must for tailoring solutions to your needs. The new Formula Handbook is here to help formula beginners and pros alike. This template contains: A glossary of all…
-
SUMIF using 2 sheets with multiple reference columns to sum a total column
SHEET 1 has the following columns: Name, Type, Total SHEET 2 has the following columns: Name, Total Used When the SHEET 2 "Name" column matches the SHEET 1 "Name" column and SHEET 1 "Type" = "PTO" then sum SHEET 1 "Total" column and place value in SHEET 2 "Total Used" column
-
Formula Question
A) I have a sheet with a drop-down menu that I would like a cell to "find" in another sheet and give me that description. THEN B) IN the Bse Price Column, I need it to go find the price for that model id and feed to that cell THEN C) I have the add-on column and need it to go find the price for the ones I have selected…
-
Recommendations for Initiating Approval Workflow
I am building an approval worflow with multiple steps. Since I will have the status columns locked, and while I am still determining if I can automate the start of the workflow, I am looking for recommendations on how the person managing the sheet can manually start the workflow. For example, she could click a checkbox…
-
Help Needed: Calculating On-Time/Late Payments and Automating Annual Summary
Hello Smartsheet Community, I hope this message finds you well! I'm currently looking for some assistance with optimizing my payment tracking sheets. Calculating On-Time or Late Payments: I'm trying to establish a reliable method to determine whether monthly payments are made on time or are late. What is the best approach…
-
Marking all tasks DONE by one click (several Levels of hierarchy)
We have project sheets with several levels of hierarchy items (parents, children, ancestors). I would like to have the option to mark all tasks DONE with one click to the highest hierarchy of a checkbox column. So far, I only found several solutions which would work on first level of indentation, but not lower levels. Is…
-
Why does my column return #INVALID VALUE in random rows
I have a training matrix and want to record total hours trained so have added a helper column to the end of each course to record the length of the course and then I have added all columns to produce total hours spent using the following formula (a bit long but only way I could get it to work!). The formula has worked on…
-
COUNTIFS formula with several criteria not feeding into metrics correctly
We are trying to map out our issues that have been reported each month, with various criteria, and how many have been closed each month. I can see the data in my report, but i cant get it to feed over into my metrics sheet This is the formula that I am using: =COUNTIFS({Amadeus: TC Known Issues & Limitations Mas Range 2},…
-
Removing a Formula
I for the life of me can't figure out how to remove an AI Formula. Any advice is greatly appreciated. Thank you
-
Formula Help: Multiple if conditions
I am struggling with the right formula for the following situation. I have a "Renewal" column that is a date. Not all rows will be relevant, therefore some rows will be blank. I have a "Asset Condition" column that is set to be one of three symbols, Yes, No, Hold. I would like the Asset Condition column to return Yes if…
-
Alert someone in a cell new form submitted but contact is not on same row as entry
Hi I have a sheet (B) which pulls back the project manager into a contact column from another sheet (A). When someone submits a form on sheet B, I want that project manager to be alerted however since the contact is only in one cell and new rows are added to top with form, the contact is not on the same row? How can I…
