-
25,000 cross-sheet references limit
I use a lot of cross references in my sheets. In one sheet, my blue arrow references have got the error code #CALCULATING on them which I know is because I must have gone over the 25,000 limit. I've archived about half the rows though and I'm still getting the same error. What am I getting wrong...? :(
-
Cross-sheet references
I'm getting the error code #CALCULATING, which I think is because I must've gone over the 25,000 limit for cross-sheet references. The sheet originally had upward if 4500 rows and I've removed more than half of them now but I'm still getting the same error. Can anyone help with this please?
-
COUNTIFS with reference to another sheet more than one criterion
I'm very confused about this function. It has an #UNPARASABLE error. =countifs({Jade2_BCM Dashboard 2019 Range 1},"Complete",[{Jade2_BCM Dashboard 2019 Range 2},"Business Resilience",{Jade2_BCM Dashboard 2019 Range 3},"1st Quarter") I am trying to reference three columns from another sheet, Jade2_BCM Dashboard, to see how…
-
Formula for common end date
I'm trying to figure out how to have several tasks point to a common end date. The tasks have various implementation dates but the "go live" time period ends at the same time (i.e., 2 tasks - one completes on 6/13 and the other completes on 7/1 but the project end date is 12/31 for both...so different durations and I don't…
-
General coding/formula questions
When coding issues get beyond the incorporated realm of Smartsheet, such as in my recent post about time/date stamping, it is my understanding that Zapier, Smartsheet API, or compatible languages come into play. So, what are the opinions in the community about this. Do most folks incorporate a conglomerate of apps or stick…
-
Help with IF AND formula
I appreciate the wealth of knowledge in this community. I have reviewed several scenarios around my similar formula, but still nothing is working. I continue to get #UNPARSEABLE. Hoping some expert out there can help!! The following formulas work independently, but I need them to work together and drive the RGYG buttons…
-
Formulat to populate a "modified (Date) cell" after a dropdown cell has been populated with "non bla
I am trying to populate a "modified (Date) cell with today's date and time stamp (date only needed) only after populating a dropdown cell with data (non-blank). I've tried NOT(ISBLANK), but to no avail. The dropdown cell is used as a status cell indicating i.e., "complete", "needs follow-up", etc. The modified (Date) cell…
-
IF Error needed????
it works if there is data in the fields but if the fields are blank - it gives me the #incorrect argument =IF([*DEPLOYED Y/N/Daytime]564 = "Yes", "Green", IF(AND([*DEPLOYED Y/N/Daytime]564 <> "No", TODAY() < [*Scheduled Deployment Date]564, "Red", IF(AND([*DEPLOYED Y/N/Daytime]564 = "Daytime Deployment"), "Yellow"))))
-
Formula for cells with multiple assignees
Hello, I have a projects list that allows multiple people to be assigned. What is a formula I can use that will count someone's name when a cell has their name plus other(s)? Thank you in advance. Formula will be used as a basis for a dashboard
-
Weighted Average & SUMPRODUCT
Is SUMPRODUCT supported by SmartSheet? If so, what would the syntax look like? Thanks. Bill