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 incorrectIn Formulas and FunctionsI 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 views 4 comments 0 points Most recent by Adriane Price Formulas and Functions
-
Resource View has unclickable Other SheetsIn Using SmartsheetSmartsheet 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…
-
"Other Sheets" in Resource ViewIn Using SmartsheetHello- 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…
-
Removing Partial Text From Prefilled ColumnIn Formulas and FunctionsHello! 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…
-
Invalid Workflow - All recipients have unsubscribed from this actionIn Using SmartsheetIn 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 views 11 comments 0 points Most recent by Andrew Arthur Using Smartsheet
-
Is there a way to customize the layout of the approval emailIn Formulas and FunctionsHi, 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…
-
SUMIFS with date rangesIn Formulas and FunctionsHello, 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 views 4 comments 0 points Most recent by deb_63_hydracor Formulas and Functions
-
Paste transposeIn Using SmartsheetHi, Is there a way to "flip" a sheet keeping links so that cloms become rows and rows become columns?
-
How to test rate limiting algorithm?In API & DevelopersI 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 …
-
Dynamic task duration (hammock task)In Using SmartsheetHi 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 …
