-
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…
-
How to calculate the difference between two values and display the result with a + or - sign
Hi community! How can I calculate the difference between two values and display the result with a positive or negative sign depending on whether the difference is upward or downward? For example, if I have two values: 5 and -2. I need the following result: -7. And if I have: -5 and -2. I need the following result: 3. Thank…
-
How to pull the top row only to sheet summary
What is the best formula to pull the top row only from the sheet I am in to the sheet summary fields?
-
SUMIF(S), AND, IF, Checkbox formula functions
Hi brainstrust, I am trying to build a resource conflict formula(s) that deliver the end results of: If a project row has overlapping dates AND has the same resource type(s) selected (different columns with check boxes) as the date-conflict project rows, return a "conflict" result. AND If a project has a resource type(s)…
-
Automation Help
Hello Smartsheet Community, I am trying to figure out a formula for when all subtasks (the children) have been checked that it will automatically add a check mark to the parent. Then, when the parent has been checked that it changes the Account Status to "Account Activated." Is that possible?
-
Formula for distinct or unique totals based on multiple criterias
I am creating a table to collect total REPORT KEYS that are unique month to month for each dept, each division and with unknown total transactions in each report key (we don't need to know how many transactions in each REPORT KEY). The data set can include up to 100 REPORT KEYS with no set amount of transactions for each.…
-
Meeting Minutes formula - automate to match meeting #
Hi All, Hope you're all well. I can't seem to figure out how to match the meeting date cell to the date that has been set in. Here's the formula I set in but isn't working. I've also asked AI but they are unable to help. =INDEX([Hidden Cols -->]@row:[Duration]@row,1,MATCH([Assigned To]$2,[Hidden Cols…
-
Linking Parent and Subtasks from a sheet into a report
Hi! I am creating a report of tasks that are in various stages, and some of the tasks have a parent/child relationship. I already tried the 'Helper column' to identify parent tasks. Is there a formula to use to identify child tasks? Also - Is there a formula I could use where instead of just listing the Parent Task Name in…
-
Count If and Not blank
Hey everyone, I am trying to count cells in a column where one column is not blank and cells in the other column matches a certain criteria. The columns are: Responsible Department - I want to count the cells in this column that are not blank and Program Name - Here is the Criteria - I want to count the cells in the…
-
Quarter Formula
I am trying to create a formula that extrapolates the quarter (Q1, Q2, etc) based upon the end date column. Has anyone done this before? Thanks in advance for any help provided.
-
Automation Workflow - External Users
Hi, I just found out today that even though I have set my Automation settings as Unrestricted, so external users with different email addresses will get notifications - in my case, Update Requests - I still have to add these domains in the Domains Safe Sharing list. Lucky that I am also an admin to my organization…