Join the Smartsheet Community
Find answers to Smartsheet questions, learn about project management best practices, discuss the future of work management, and get how-to guidance for every Smartsheet use-case from fellow users and Smartsheet experts.
Discussion List
-
Pre-populate a formIn Using SmartsheetI am building a change control log. Is it possible to pre-populate a form with cell data from a sheet? For example, project name, ID, customer, description and resource from the sheet to help the process of logging a change to the change c…
-
I have four cells that require approval, I want to create a formulaIn Formulas and FunctionsI have four cells that require approval, I want to create a formula that says if all four cells are blank then the cell for approval status is red. If all four cells are not blank then "Green" for approved. I am a novice user and…
-
Why is DATEONLY() returning the wrong date?In Formulas and FunctionsHello All, Does anyone understand the behavior of the highlighted cell below? I believe it should be displaying "08/18/20".
-
Auto check box using =IF([email protected]="California",1,0)In Formulas and FunctionsThis formula works as typed. However, I need your help writing this formula such that it will auto check box if the word is "California", or "Florida", or "Arizona".
-
Linking Microsoft Documents to Smartsheet Dashboard / WorksIn Apps, Integrations, and Add OnsHi, I am trying to link ppt and a word document on a smartsheet dashboard and workapp. I am getting the following error how can i resolve this? Thanks!Accepted Answer 23 views 2 comments 0 points Most recent by Christine Odongo Apps, Integrations, and Add Ons
-
Set RAG based on % Complete & Deadline Date ProximityIn Formulas and FunctionsHi I am trying to get my formula to set a RAG status based on the % complete and deadline date proximity. My formula is: However, the last entry with a deadline date of 12/11 show be showing a "Yellow" RAG but, it still shows &q…
-
SUM Providing Wrong NumberIn Formulas and FunctionsThis discussion was created from comments split from: SUMIF value exists, leave blank if cells are blank (nothing to sum).
-
Count Formula for At-RiskIn Formulas and FunctionsHello, Im trying to count all the At-Risk items for a specific team in the sheet summary. I have a Status column and a Team Owner column. Ideally, I would like to know what the formula would be for capturing the number of items At-risk fo…
-
Sumif formula problemIn Formulas and FunctionsHi, I'm trying to modify this formula: =SUMIFS({Total Sq Ft Scanned}, {Field Status}, "Completed", {Field Work Completed Date}, AND(IFERROR(MONTH(@cell), 0) = 7, IFERROR(YEAR(@cell), 0) = 2021)) The Field Status column is a dro…
