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
-
Automating a push notification based on a cell valueIn Using SmartsheetI have an automation process where I need to push a notification based on a specific time value within a cell. So the data's coming in from a form with the date and the hour a phone call needs to be made. I.E 14:00. When 14:00 rolls around…
-
Smartsheet: Customers intermittently being logged out with a session timeout.In Using SmartsheetHello all, Starting November 23rd around 9:30pm Pacific Time, we began receiving reports that customers were being unexpectedly logged out. More details can be found here: https://status.smartsheet.com/incidents/7qrz2djs5lgs We have narrow…
-
How to display Name of the user who created record?In Formulas and FunctionsCreated By displays email. How can I display the actual Name of the user who submitted record through form?
-
Not IS Blank or IS Text formula to mark a symbolIn Using SmartsheetUse Case: I would like a cell to change symbols (red for example) based on whether or not a given row has text (any text). I've tried =IF(ISTEXT([What should we stop doing?]@row, "Red"))) Returns UNPARSEABLE I've also tried =IF(N…
-
Bring the data in a cell over to another sheet based off of other conditions in a rowIn Formulas and FunctionsWhat would be the best way to bring the data in a cell over to another sheet based off of other conditions in a row? Example: =IF(AND({Sheet A Type} = "Project Status", {Sheet A Status} = ""), {Sheet A % Complete}, &quo…
-
Workflow to Update Date to TODAY() until another cell = 100%In Formulas and FunctionsI have 2 cells in a column: Which displays a % from 1-100 Which should show a date Is it possible to use a workflow or other automation to daily (at 12:01am or any other time) update the date field to TODAY(), but to stop updating it once …
-
Status related to % CompleteIn Formulas and FunctionsI am trying to accomplish the following formula: 100% status turns green 1%-99% status turns yellow 0%= Gray work paused = red Is this possible with red?
-
Formula to count specific namesIn Formulas and FunctionsHello! I am trying to create a formula which counts how many times a name has been inputted in a month. For example if my name was added three times in December, I would like for there to be a three next to my name. Is there a way to do t…
-
Include Multiple Recipients on Single Email AlertIn Using SmartsheetWe are currently using a form to track internal requests. We are trying to get smartsheet to send an email to multiple recipients on a single email thread. Essentially using this form to generate an email thread which has all of the foll…
-
IF & VLOOKUP Formula Only Returning First Value FoundIn Formulas and FunctionsHello, everyone. I'm having a problem where I'd like the formula in [Column 3] to report the value in [Primary Column] only if the checkbox in [Column 2] is TRUE (checked). (In the real sheets, the VLOOKUP formula in [Column3] is on anothe…
