Hi! I think my question is pretty simple. On a sheet, I have two columns. One is "Primary", and it's blank. The other is "Created" - a date/time column that auto-populates from a form. I want the prim…
I want to create a master sheet that connects to a report for each customer in the data. In this master sheet I have a column for "Average process completion time". In the master sheet, I want it to d…
Hello, I have this formula which works as I'd like but what I'm missing is if the answer is zero I want the formula to give me 0 as a response, instead I'm getting #Divide by zero. Any suggestions of …
Hello! I've been working on this formula for hours now and could use some help. I have a column called "Program Date" and a column called "TR". If Program Date is between 12/1/24 and 4/30/25 AND TR is…
Hi there, I am having some trouble calculating the average of the "RYG Average" column for the child rows in my Smartsheet. I have a helper column called "Parent Row" that has a checkbox for any rows …
Hello everyone, long time watcher, first time caller, I've been search for an answer for a while on the forum but I can't seem to get it to work. I am trying to highlight duplicates entries based on m…
I asked this question before and got a solution but now it is counting starting at 1 instead of 0. this is the formula used =IF([Date Closed]@row = "", NETWORKDAYS([Date Opened]@row, TODAY(0)), NETWOR…
Hi, I'm wanting to create a timesheet where 1hr = (ex.) £10, and hours can be input by an individual and the smartsheet will work out how much they are owed. First calculation to be row, 5hrs = £50, s…
I have requirement to review the TYPE and return the Food value in unique list The outcome should like this written a formula like this like this =IFERROR(INDEX({Range of "Type"}, MATCH($[Food], {Rang…