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

  • IF Formula - 2 Conditions and 1 Flag
    In Using Smartsheet
    I have a column that houses a flag to notify if the billed hours breach the budget. But I am trying to use two conditions where it doesn't run if Contract Type contains T&M. My first attempt right now: =IF([Billable Consultant/Develope…
    Accepted
    7 2
    Accepted Answer 7 views 2 comments Most recent by Mike Buckiewicz Using Smartsheet
  • Selecting a week number based on custom criteria
    In Formulas and Functions
    Hi everyone! I'm trying to avoid a nested if statement such as: if([start]@row>"10/4/21" AND [start]@row<"10/8/21",1,if{[Start]@row>"10/10/21" AND . . . and so on for the next 25 weeks. My initia…
    Answered - Pending Review
    18 2
    Answered - Pending Review 18 views 2 comments Most recent by kolfinna Formulas and Functions
  • Controlling how a sheet is opened
    In Using Smartsheet
    Anyone have a way to open a sheet fully collapsed? My user wants her sheet collaborators to use a Portal to access the sheet AND wants that sheet to open in a fully collapsed state to make it easy to navigate to the specific quarter of th…
    Answered - Pending Review
    7 1
    Answered - Pending Review 7 views 1 comment Most recent by Genevieve P. Using Smartsheet
  • Published calendar on Outlook - wrong dates
    In Using Smartsheet
    Hi, everyone. I am having an issue with dates when publishing a sheet to iCal. The sheet has several date columns, and it has the following settings (images below): "warranty expiration" as the sole date for the calendar calendar…
    Answered - Pending Review
    7 2
    Answered - Pending Review 7 views 2 comments Most recent by Genevieve P. Using Smartsheet
  • How to get Smartsheet to recognize an imported date
    In Using Smartsheet
    These dates are coming from our ERP system imported via Data Shuttle, having trouble getting Smartsheet to recognize them as dates, when I try to use them in formula its always an invalid data type. If I switch the column to text/number t…
    Answered - Pending Review
    15 2
    Answered - Pending Review 15 views 2 comments Most recent by Paul H Using Smartsheet
  • What can i do for unlock my account?
    In Using Smartsheet
    My account was canceled, so i want to do the payment to use but i can´t do this. I just sent a e-mail to support smartsheet, but till now i don´t have a solution.
    Answered - Pending Review
    9 1
    Answered - Pending Review 9 views 1 comment Most recent by Genevieve P. Using Smartsheet
  • Simple change cell workflow not working
    In Using Smartsheet
    Hi, I have created a very simple workflow to change a cell (check a checkbox) when a status changes to "Complete." It is not working. I've had the same problems with similar workflows - (Add text to a notes field when a status …
    Answered - Pending Review
    119 12
    Answered - Pending Review 119 views 12 comments Most recent by Scott Adams Using Smartsheet
  • Pivot Count Formula Column
    In Apps, Integrations, and Add Ons
    Does Pivot count values in a formula column? I've tried to write a pivot from a Report source where the column and values are the same formula column - it runs endlessly "Creating". Help Please
    Answered - Pending Review
    19 1
    Answered - Pending Review 19 views 1 comment Most recent by Jaykel Torres Apps, Integrations, and Add Ons
  • Workflow to be triggered when cell is changed to specific value
    In Using Smartsheet
    Hi all, I would like to create a notification workflow to be triggered when cell is changed to specific value. Is this possible? Thanks in advance!!
    Answered - Pending Review
    8 1
    Answered - Pending Review 8 views 1 comment Most recent by Andrée Starå Using Smartsheet
  • workflow to be triggered when cell is changed to specific value
    In Using Smartsheet
    Hi all, I would like to create a notification workflow to be triggered when cell is changed to specific value. Is this possible? Thanks in advance!!
    Answered - Pending Review
    20 1
    Answered - Pending Review 20 views 1 comment Most recent by Andrée Starå Using Smartsheet