-
Last update Formula (Sheet Summary)
I need to make a formula that identifies the last modified date on my sheet
-
Count Ifs with multi-select
Hello I'm trying to do a count if with a multi-select column and am using the find formula. It is referencing another sheet. can you please let me know if I have any errors here? I get #Invalid Data Type.
-
Automated Move Rows won't move anything
I have an automation set to run whenever a "Status" row changed (or row is added) with a condition: "Where Status Contains 'Out of Service'". It's set to alert me, then move rows. It alerts me just fine, but won't move any rows. Using the row options to move the rows works with ease, and no error messages ever appear. My…
-
How do I calculate a formula to alert 6 months before a travel date from a passport expiry date?
I'm lost for creating a formula to create an alert from 6 months before a travel date (column labelled): Trip Start Date (office) from a passport expiration date (column labelled): Expiration Date by highlighting the Expiration date (YELLOW) and notifying shared sheet owners.
-
In need of formula to check box using based on data from 2 columns
My best try was: =IF(AND([To Be Filed]@row > 0, 1, [Days Since Close]@row < 60, 1)) Got any ideas?
-
Combining IF statements
Hi Smartsheet community, I am currently trying to create a formula, that states if Updated Completed Date is blank then use the date in Original Completion Date column but if not blank then use the date in the Updated Completed Date column to return quarter and year (Q4 2020). I am creating this formula in the Estimated…
-
Lookup text and calculate values in cells from columns in the same row
The formula I'm using for this is working, but it feels like it could be completed in an easier way. I want to look up the text "Grand (Total)" from the Rows column then divide the numbers from the Audits and Findings columns in the same row. Any suggestions on how I could shorten this formula?
-
Adding up only the numbers that meet a specific criteria in another column
As stated in the titled above, I am trying to figure out how to do a formula that adds certain numbers together in a column, based on if the text in the column next to it, on the same row, is a certain value. Example - Add Column B's Hours together (.5 +3 +6) but only if the column next to it in the same row says "…
-
How do I add another IF statement to a Workdays calculation?
I am using the following formula (from a template) top calculate Working Days Remaining for a task - =IF(ISERROR(NETWORKDAYS(TODAY(), [End Date]@row)), "", NETWORKDAYS(TODAY(), [End Date]@row)) However, I want to add a condition to this that if the Status column for that same row is marked complete, then the Working Days…
-
Formula for Max Value and Row Name
Hello - I am trying to pull in the max value of column A and the name(s) associated with that value. I am trying to use the following formula to pull in the max value and taking into consideration there could be multiples of the max value: =LARGE(DISTINCT([B]$1:[B]$7), #) And then I would like to show the value(s) in…