-
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
-
Updating a current formula for a report in a widget to include dates
I have an issue where the current formula feeds into the report correctly and displays on the dashboard widget however, I have now been asked to change the formula to be date specific. I need to have this display by our fiscal year (July 1, 2018-June 30, 2019). Pro-desk gave me the formula to copy and paste but the…
-
Report Viewability
So I have created several Reports and have noticed that when you add them to a Dashboard, anyone with Dashboard Access can view them as a Widget; however, When made a viewer on the Report itself, all the people see is a blank page. Do the Viewers also need access to the sheet the report is pulled from? If so then reports…
-
Automatic antick
Hello, I have a particular situation: 4 columns defined as checkbox. The description of the columns reflect a sequence: Open, In progress, Pending and Closed. I need that when I tick a subsequent columns/status the previous one (or the others) will be automatically unticked. Could you please help me? Thanks and regards.
-
If, Then Formula
Hi everyone, I've searched through the community but couldn't find the right solution. I need to feed specific sales metrics into a dashboard but want it to update, according to the Today column. I receive the previous months information on the 15th of each month, so the formula would need to cover a 45 day period. I added…
-
Increased Cell references
Anyone know when (or if) Smartsheet plans to increase the number of cross-sheet cell references? I am getting this message now in my sheet, and its frustrating because I feel I have only started to truly make my sheet smart and truly useful. Does anyone have any "best practices" to share? I am currently referencing 5 or 6…