-
Calculate total time onsite
Looking for help to determine total time on site between different columns. Need calculate to come out in hours and minutes. Example: Column 1: Day 1 onsite: 8/18/23 22:00 Column 2: Day 1 Offsite: 8/19/23 10:00 Column 3: Day 1 Hours: Need calculation of hours here. Any help with the formula here would be really…
-
Checkbox, Texts, RYG
I am trying to create a formula based on checkbox and dropdown list column. The result I am looking for is for Column 3 to have either a Red or Green symbol based on if Column 1 is checked OR Column 2 includes a specific word. Column 2 is a drop down with multiple options. Is this possible?
-
Is there a function to get information from the activity log and add it to a cell?
Necesito grabar ese valor de fecha por medio de una función ***Translated via Google Translate as the Community is currently only supported in English*** I need to record that date value by means of a function
-
Using Join(Collect to collect data from multiple sheets to populate in (1) cell
I am looking to combine data from (3) sheets into one sheet. There will be 3 columns: Team, Assignment, and Notes The cells in the Team and Assignment columns from Sheet1, Sheet2 and Sheet3 are populated from a multi-select dropdown lists. Notes are free type. Example: p-id on the destination sheet is xx, Sheet1 and Sheet2…
-
Index/Match Leaving Blanks + "#NO MATCH"
I apologize if this posts twice... I am a relatively new Smartsheet-er experimenting with the capabilities of the Index/Match function. I have two sheets, one that tracks project status, and one that I would like to link to the first, showing live project status updates by matching the ID # columns. I have created a…
-
Count multiple criteria
I'm looking for a formula to count a single criteria from one cross sheet column and multiple criteria from another column. Any suggestions? =COUNTIFS({My Sheet - Status}, "New Request"), {My Sheet - Unit}, OR(@cell = "Library", @cell = "MGEN", @cell="NuRes", @cell="OARS", @cell="ODEI", @cell="OTP", @cell="Registrar",…
-
IFERROR Statement with COUNTIFS, AND, OR.
Hi Community. I want to add an IFERROR statement to a formula on a Calculations Template sheet. This one is fine: =IFERROR(COUNTIF({Status Range 1}, ="Submitted") + COUNTIF({Status Range 1}, ="Rejected - Further Detail required"), 0) I am struggling to get it to work in this Calc: =COUNTIFS({Tracker Range 3}, "Red",…
-
Writing today's date into a cell when the Status value in the same row contains "Complete" or "N/A"
Hi Community! I try to write today's date into a cell when the Status value in the same row contains "Complete" or "N/A". Any suggestions or hints how this formula could look like? Thanks!
-
COUNTIFS with an OR in it
Hi Community! I am struggling with the below COUNTIFS formula which basically has to have an OR logic in it... =IF(Date@row <= TODAY(), COUNTIFS(OR({Status 1}, "Complete", {Status 11}, "N/A"), {Planned End Date 1}, <=Date@row, {Parent Child 1}, "Child"), "") There must be a syntax error, but I can't find it. Any hints or…
-
Reference flag from one sheet in another
thank you in advance. how do you write a formula that looks at another sheet for a condition present in one column and then look at another column in that sheet to see if it has a flag? appreciate you!
