-
Time
Hi all Is anyone aware of any time functions is recent updates, I what to be about to calculate how minutes/secs(don't mind either) from a system column also is there an hour or minute function in Smartsheet? thanks in advance
-
Parent row based on children status and due date formula
Hello, I have a sheet that tracks event deliverables for 150 or so events each year. The way the sheet is set up each parent row is the event name, and then the children rows are each task for that event. I have a column for Status with the options for Complete, Not Started, and In Progress. I want to create a new column…
-
Sumif if question
Hey folks, Working on a sheet to sum up if checkboxes are selected and running into an issue. The formula I have now is- =SUMIF(PRD50, 1) + IF(Stories50, 1) + IF(Assets50, 1) + IF(Wires50, 1) + IF(Comps50, 1) Each one of those are checkboxes and I want to tally them all up. Ideally, I'd like it to equal 100 since that…
-
Sheet formula to access members in a group
I've created a Group and can track assigned tasks in a Resource View with the group dynamically. Is there a way to access the group list in a formula on a sheet? In my sheet, there is an "Assigned To" column which is a Contact List type column. The cell can be assigned to group members and non-group members. The next…
-
Creating formula to insert text data from one cell to use as hyperlink address for other cell
Hi guys, very new to formulas so not sure if this is even possible and/or makes sense. I have a web form that lets the user submit data for: NEWS PIECE TITLE NEWS PIECE FILE (UNC path) Then, I send an Update Request to our website team who upload the "NEWS PIECE FILE" from the UNC path onto our website, and provides the…
-
Formulas
I'm Trying to add a function to the following formula in which adds "should the cell to the right of this formula show anything else except completed then the formula will display BEHIND =IF(AND(TODAY() + 1 >= [Completion Due Date]29, [Days to Completion]29 < 100), "BEHIND", "")
-
Calculating the duration between 4 dates
Does anyone know the formula to count the days between 4 dates. If the Ready to Launch date is greater than or equal to the Received IO, then the Duration would equal the number of days from Start to Launched. Otherwise, the Duration would equal (days from Start to Ready to Launch) + (days from Received IO to Launch).…
-
Index If?
Hi. I'm trying to retrieve a cell value from one sheet to another where it looks up the ID# and retrieves the Score. However, I want it to retrieve the most recent Score, because the sheet it is retrieving from is a historical record with many different scores assigned to that ID# over time. Could someone help me with the…
-
Formula help - trying to sum a column if launch date is in the next 30 days
Hello, I'm trying to sum numbers in a column a if the launch date is within the next 30 days. Thanks in advance for any help!
-
Reference a Cell in another Sheet in a Formula?
Howdy! I'd like to count the number of occurances of a specific value in a column on another sheet. It works great this way, but within the same sheet: =COUNTIF([Column4]17:[Column4]26, "Red") Is there a way to select a range of cells on another sheet and return (in this case) the number of them that are Red? Thanks!
