-
How do I use the attachment column in a Sheet Summary Formula?
I want to write a sheet summary formula that counts how many rows where the MoSCow column contains M, have attachments. The syntax I am using is COUNTIFS( range1, criterion1, [ range2,criterion2]). I have used this formula many times Getting the column criteria (range 1, criterion 1)specified is straight forward. But I…
-
Convert to Formula Greyed Out
I'm pretty new to Smartsheet and can't figure this out. When I right click ON THE CELL, the "Convert to Column Formula is greyed out" I am an admin I'm the owner of the sheet The formula does NOT contain specific cell references: =IF([Task/Project Type]@row = "Meeting: Once", "0", [Completed Date]@row - [Start/Started…
-
Formula for "Days since" event
Hi There, I'm looking for some help with a formula for a sheet summary field. I'd like the field to display the number of days since "today" that a checkbox was checked, based off the date entered in that checkbox's row. Example based off screenshot: "Today" is 12/4/2023. If the checkbox for Row 66 is checked the "Days…
-
Hi, i am trying to multiply number in column "Lineal Meters" by 3.2. What is the formula please?
-
Countif This Month, Next Month, Following Month
Heyo, I am trying to redo a formula to auto update with the information that I am currently pulling monthly for a dashboard. I am trying to sum the total fee installed if scheduled to complete this month, next month, and the following month. Here are the formulas I am using: This Month: =SUMIF({ECD}, IF(ISDATE(@cell),…
-
=IF(CONTAINS 2 Red Harvey balls they status changes to "red".
Hello! It's me again, Is it possible to have a formula that the Harvey Ball in "Overall Status" changes depending on the other 4 rows? IF I have 4 Green Harvey Balls the "Overall Status" is GREEN IF I have 3 Green Harvey Balls the "Overall Status" is YELLOW IF I have 2 Green Harvey Balls the "Overall Status" is RED I have…
-
Formula Range no longer working
Hello - We have a report that is built to feed a dashboard. It has worked fine for close to a year. Today I logged in to complete our weekly report email, and all of my forumulas are showing the #INVALID REF error. When looking at the formula, the 'range' is still there, but it is no longer actually working, it does not…
-
Count on condition between two dates
I have been racking my brain on how to write this formula - for some reason, it did not count anything What I am trying to do is: Count "Complete" between two dates. The formula goes: =COUNTIFS([Actual Start Date]:[Actual Start Date], ">=12/26/2022", [Actual End Date]:[Actual End Date], "<=05/26/2023", Status:Status,…
-
Displaying Multiple Quarters based on Start and End Date
Hi - I would like to request assistance with developing an equation. The equation needs to display one or many Quarters based on the 'Start' and 'End' date of a task. Many of the equations I have tried display the quarter in which the events starts. However, I would like the equation to support the following: If an event…
-
SUMIF Budget when priority does not equal x
I've tried to review this older post (among others) to see if I could figure out why my formula was not working. But was unable to sort out why. Trying to SUM a budget column if the Priority column does NOT equal "N/O" =SUMIF([Priority]:[Priority] <> "N/O"), [Budget]:[Budget]) =SUMIF([Budget]:[Budget], Priority:Priority <>…
