Hello! I'm trying to create a formula that will generate a weighted sum total across a couple of criteria columns after each column has been assigned a score. Each of the columns will have a drop down…
I made typo in one of my formulas but it still returned the desired result. I want to understand so I don't end up with unintended results down the line. My goal is to extract the data that follows "S…
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 …
