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

  • Formula to pull in fiscal work week is incorrect
    In Formulas and Functions
    I am continually getting the incorrect work week. In the below screen shot the Onboarded Week should be Week 16. Attached is our lookup sheet from smartsheet. Our fiscal week starts on Saturday, January 29, 2022 and the fiscal week ends on…
    Answered - Pending Review
    20 4
    Answered - Pending Review 20 views 4 comments Most recent by Adriane Price Formulas and Functions
  • Resource View has unclickable Other Sheets
    In Using Smartsheet
    Smartsheet Community: I Can See All my Resources but I can not see all the Sheets they are Assigned to. It Displays Other Sheets. I Own Every Sheet that they are Assigned to. Does Anyone know why Resource View is Only Showing One Sheet an…
    Answered - Pending Review
    52 7
    Answered - Pending Review 52 views 7 comments Most recent by grayminds Using Smartsheet
  • "Other Sheets" in Resource View
    In Using Smartsheet
    Hello- My username is identified as a resource on "Other Sheets" in the Resource View - which I can't identify. Is there a way to see what those unlinked sheets are? I suspect it might be from a client's Smartsheet - is there a w…
    Answered - Pending Review
    55 3
    Answered - Pending Review 55 views 3 comments Most recent by grayminds Using Smartsheet
  • Removing Partial Text From Prefilled Column
    In Formulas and Functions
    Hello! I'm currently using the following formula to extract just the time =SUBSTITUTE([Completed Timestamp]@row, DATEONLY([Completed Timestamp]@row), "" When used with automation/move by a check box being true, it populates corre…
    Answered - Pending Review
    26 2
    Answered - Pending Review 26 views 2 comments Most recent by Jimrny Formulas and Functions
  • Invalid Workflow - All recipients have unsubscribed from this action
    In Using Smartsheet
    In some of the workflows created by our users, it indicates that the alert recipients were unsubscribed from the alert action and the whole workflow became invalid. However, our users did not touch anything on the setting they did not clic…
    Answered - Pending Review
    374 11
    Answered - Pending Review 374 views 11 comments Most recent by Andrew Arthur Using Smartsheet
  • Is there a way to customize the layout of the approval email
    In Formulas and Functions
    Hi, I have an automation set up that sends the data to an approver who either approves or declines. They can comment but was wondering if 1- we can put comments at the top of the email and the fields below 2-can we remove the access to the…
    12 0
    Question 12 views 0 comments Started by melimitch Formulas and Functions
  • SUMIFS with date ranges
    In Formulas and Functions
    Hello, I'm trying to sum the values (Annual Billing Amount) for anything that falls between 2/22/22 and today but I can't get my formula to work. Not sure what I'm doing incorrectly. =SUMIFS({Annual Billing Amount}:{Annual Billing Amount…
    Answered - Pending Review
    12 4
    Answered - Pending Review 12 views 4 comments Most recent by deb_63_hydracor Formulas and Functions
  • Paste transpose
    In Using Smartsheet
    Hi, Is there a way to "flip" a sheet keeping links so that cloms become rows and rows become columns?    
    1050 3
    1.1K views 3 comments Most recent by Mary Ambrose Using Smartsheet
  • How to test rate limiting algorithm?
    In API & Developers
    I am building an app that I hope (and believe) will rarely if ever hit up against the Smartsheet rate limits. But of course in building a resilient app, I have to consider that it might. So I have built out a framework for handling rate …
    36 2
    Question 36 views 2 comments Most recent by sgolux API & Developers
  • Dynamic task duration (hammock task)
    In Using Smartsheet
    Hi all, I am looking for a way to create tasks with a dynamic duration that is prescribed by the relationship between what comes before and after the task. For example, if there are two sequential tasks that need to be completed before …
    Answered - Pending Review
    19 2
    Answered - Pending Review 19 views 2 comments Most recent by MNML Using Smartsheet