I'm currently working on making two separate sheets. One is where providers can submit that they have extra of something (someone submits that they have 5 extra bags of concrete, another person submit…
Hi Smartsheet Team, I have captured this student id no. 2307647 Programming session hours is 1.5 hours. (see below) Then, I worked on the metrics sheet to show the hours on the programming session - C…
Hi all, I need to add a date and time check to a SmartSheet I am working on. Currently, we are trying to track late arrivals into our building. Example: =IF([Actual Pick Up Time]@row > [Critical Pull …
Hello, I want to count the number of tickets that were opened in 2022. I am getting a invalid date type error message. The date range in the cross reference is restricted to dates only. =COUNTIF({Date…
Hi, I'm using the following formula to calculate the difference between 2 times: =IFERROR((VALUE(LEFT([End Time]@row, FIND(":", [End Time]@row) - 1)) + VALUE(RIGHT([End Time]@row, 2)) / 60) - (VALUE(L…
Hi, I have a Join/Collect column formula that I'd like to add a timestamp to. Is this possible? If not, is there a workaround? Sheet1 contains a list of Accounts populated with answers from a question…
I have a field that is calculating the average of days, which comes in as a decimal. When I go to add this decimal number to a date to get a future date, it only uses the whole number of the decimal, …
Hi all, I have 3 different sheets set up. Sheet 1 a list of names with assorted data for each name. There's a check box that will move rows to sheet 2 if checked. Sheet 2 contains data that was moved …
I have created a log book request form that needs to generate a unique ID (YYYY-##-###) based on 3 criteria: Year submitted (4 digit year), Site Code (preassigned 2 digit site code), and Log Book Type…
Hello, my current formula only counts what month a row was submitted but not the year. How can I get the formula to also count the row if it happened in January of the current year? =COUNTIF({Date Sub…