-
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…
-
COUNTIFS Formula Based on Status and Due Date
I'm looking to create a formula that will count the number of overdue tasks. This is based on the "assigned to", "status" and "due date". My current formula is =COUNTIFS({[Sheet Name]}, <TODAY(), {[Sheet Name]}, ="[Assigned To]"). However, this is pulling tasks that are due in the past, but are completed.
-
% calculation for parent overview
In the above image the green is the parent line, where some are calculating the child line %'s below, however in the lower half of the image it's not doing so. Any suggestions please? Thanks!
-
Checkbox Evaluates Differently
I have a checkbox column [H-SD (Added)[ with this formula: =IF([H-Supplier Type]@row = "Individual", IF(COUNTIF({SD-EmailPrimary}, [Email (Primary)]@row ) > 0, 1, 0), IF(COUNTIF({SD-EmailPrimary}, [Organization (Email)]@row ) > 0, 1, 0)) In another column, i want to evaluate if that column is checked or not, so I put this…
-
Keeping attachments with Index row value
I have a sheet where I query 14 other sheets to collect all sorts of data (unique values from sheet into a column) and in another column I use an Index distinct collect to get all the unique value from those 14 columns, this is the 'Index' column. At some point a user will want to generate a certificate associted with the…
-
Dynamic Array Formula Help
GOAL: Create the most efficient formula that can drag across from Column "1" Row "2"and down as project budgets are activated (by form submission adding rows to the bottom of the sheet) and subsequently drawn down. Target Sheet has 60 project budget columns to the right of Project Kickoff, most blank, to allow additional…
-
How do I list all predecessors (direct and indirect) for a given row?
Does SmartSheet have a way to list out all of the predecessor rows that feed into a given row? For Row 22 in the example below, I would like the formula to return the values 20, 19, 18, 17, & 16. Either that, or I would be looking for a list of all direct and indirect successors to a given row. Either would get me where I…
-
Gantt Presentation
We run our project delivery sheets in Smartsheet and are required to present them to clients on a monthly basis so they can see status updates and timelines. When we print to PDF, it reduces everything on A3 to tiny print and the client has to increase the view to see what is written. One of our clients uses another…
-
helper row and determining the earlier of 2 finish dates
Hello, I have task 3 which is dependent on task 2 and task 1. I want task 3 to start when either task 2 or task 1 is completed. How do i implement this in Smartsheet gov? below is a screenshot of what I tried but it does not seem to work. Any suggestions?
-
INDEX/MATCH ERRORS
I have used the index/match formula successfully , but in my current project, for some reason it isn't working. I have my two sheets (Open Adp) and (A/N Referrals). In Open Adp, there is a Case ID and then a person's name associated with that ID. I'm trying to have the person's name from Open Adp sheet be pulled over into…
-
Conditional Formatting in Rows Resulting from Formulas
Hello, This might be somewhat of a long/confusing one. I am trying to figure out how to better automate categorization for blood pressure categories when being placed into a sheet. For example, in the image below the column "BP" is where the initial number is input. I then put a LEFT formula in the column "Sys formula" to…