-
Quarterly Revenue Tracker that rolls over YoY
I've created a revenue tracker for 4 quarters but the date ranges are fixed and last timeframe has passed it will need to be updated. How can i add a function so revenue can continue to be tracked without my intervention? Here is a snap of my formula which actually covers the last 2 Q's of 2021 and first 2 Q's of 2022.…
-
Count+Distinct
=COUNT(DISTINCT(CHILDREN())) I using the formula above to count the distinct number of bays for different shipments, some shipments would have all of the bays in one cell. Is there a way to modify this formula to count the bays within one cell separately? (for clarification the example above would be 3 distinct bays while…
-
Time stamp for column edits?
Is there a way to collect a time stamp of the last time a cell has been updated? More specifically, when I send an update request to a user, and they respond I would like a time stamp to then set a reminder to follow up 30 days after they responded. Thx!
-
Pulling information based on dropdown selection
I'm pulling information from 1 sheet into another to be used as a dashboard reference and i'm having trouble with a formula.. I need to collect names if "awarded" is selected in a separate column's drop-down. Is there a way to do this?
-
Reference Formula
Hello SmartSheet Community, I need a formula that can detect if a name has appeared on other sheets I've used in the past. I have a column named "Duplicate" that I would like to have automatically checked if someone enters a name under the column "Name (Last, First) that has already been entered on sheets columns labeled…
-
AND(OR Statement Help
I'm getting stuck on this one. I have a working OR statement formula based on no information from two different columns. I want to add a third variable based on another column having a specific statement. I've tried this a few ways but, nothing has worked. Working Original statement: =IF(OR([ePRG Training]@row <> "",…
-
Get the latest value of multiple matching entries.
Looking for the right formula to look at the list of entries and IF the Contract Number AND Invoice Line Item Number match. The example screenshot shows 4 lines. They're all the same contract, but the 4th line item is a duplicate entry of "A". SO I want the "Latest Contract Amount" column to keep the latest value entered…
-
Getting multiple Fields from 1 row using MAX and COLLECT
I have a sheet (IDF Check) that contains static information about my IDF's that I want to use as a kind of dashboard. I have a second sheet (IDF Checklist) that collects information from weekly checks on the IDF including Date and time checked, the inspectors name and a calculated field of the overall status of the IDF.…
-
Formulas to identify current project phase, next task due on a project plan and the task due date.
Hi everyone, To help us report the current position of a number of projects, we have been asked to report on the current phase and next due task. So I need to find formula's that can identify the following 3 things:- What is the current phase of a project. On example below, "Defined, Scoped and Analysed" is the current…
-
=INDEX(COLLECT(
Hello, I am trying to return a value based on 3 criteria but am getting the #INVALID VALUE error. Sheet 1 contains my the 3 deciding factors (Single Point of Failure?, Business Impact and/or Safety Related, Lead Time to Procure) and my desired output (Critical Spares Suggested). Sheet 2 is the user tool that is looking for…
