-
Calculating The Time for Another Time Zone
Smartsheet Community: Is There a Formula I can Use to Pull The Time for The Modified Date Column Type and Add 6 Hours to Give Me That Time? Example: Current CST Time (Column Type is Modified Date) = 11/26/24 4:08 PM Current CST Time Plus 6 Hours 9Column Type is Text) = 10:08 PM Thanks
-
How to Automatically Checkmark a Column for entries that are created within a time-based timeframe
I'm trying to write a formula that will automatically place a checkmark in a checkbox column titled "Today Entry" whenever entries meet the "Created" column criteria of being submitted after 1100 AM the day prior and 0800 AM today on a rolling basis: I've been trying to use the below column, but honestly I have no idea. I…
-
Inspection tracking template - functions
Hello, I am using the Inspection tracking template and it includes the following function: =COUNTIFS({MED1}, "No", {Date}, MONTH(@cell ) = $[Month#]@row) I would like to measure the number of violations per room, rather than per month but I am having difficulty knowing how to change the {Date}, MONTH(@cell ) =…
-
Formula that includes referencing multiple different grid reports and ranges
We are looking for a formula that reference how many items they completed throughout the year, by looking at a persons name. Problem is we have to use multiple grid reports and ranges to find the total of items completed for the year. Does any one know of ways to reference multiple grid reports into one equation. Example…
-
Pull data from different column based on current date
I am looking to use the sheet below that was created that has hours of projects by week. Each project is on its own line I am looking to return all hours from this sheet for the "current week" this will obviously change based on the date. I think there isn't a way to dynamically change the column referenced. Can you help…
-
NEED TO ADD DAYS TO THIS FORMULA IF ANOTHER CELL HAS SPECIFIC ITEMS OF A DROP DOWN.
I have this formula that works for this cell when information is missing from reference cell A. However now we want to be able to add additional days if reference cell B has specific items checked in a dropdown. I just can't seem to get it to work. Any suggestions. =IF(ISBLANK([ ENGINEER (tentative start date)]@row), "",…
-
#Divide by zero error for AVG COLLECT
My formula is giving an error. it works fine until I try to add the month. The month calculated field is a number/text field. What else could be the issue? =AVG(COLLECT({DYS to Completion}, {Application}, [Column5]@row, {Month}, =1))
-
Conditional Dropdowns functionality, not available yet?
Hello everyone, I’ve been working extensively with Smartsheet and noticed a significant limitation that has been discussed for years but still hasn’t been addressed: conditional dropdowns. Here’s the scenario I’m struggling with: In Column A, the user selects an option (e.g., "Option 1"). Based on that selection, the…
-
Calculating the total duration from a date & military time start and end
I have been looking at a lot of information on this site and this is the closest one I have found, however it does not calculate the minutes correctly. For example instead of 8hrs and 45 min it gives me 9hrs and -15min. Formula: =(([On-Site Date]@row - [Notification Date]@row) * 24) + VALUE(LEFT([Time of Crew arrival]@row,…
-
Check a Box if Between Dates on Another Sheet
Hey all, I am trying to build a formula to check off a box on my sheet if at least one date is found between two dates on a separate sheet. I've tried a million variations but here's what I have so far, thinking I was overcomplicating things =COUNTIFS({Approve Date}, >=[Week Starts]@row, {Approve Date}, <=[Week Ends]@row,…