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
-
AutomationIn Formulas and FunctionsHello, I am looking for a way to condition a symbol column to updated from a text column. Any tips?Answered - Pending Review 8 views 3 comments 0 points Most recent by Andrée Starå Formulas and Functions
-
How do I setup a flag for duplicates?In Formulas and FunctionsHello, First time posting here ☺ Trying to setup a flag for when the same data is entered in a row, but it's giving me a hard time ☺ help?
-
Notification when a specific task changesIn Using SmartsheetHi. I would like to configure workflows or notifications so that if something changes (say a conversation) in a particular task, then the people who are listed in the notification column will get an email notification. We are going to a…
-
CalendarIn Apps, Integrations, and Add OnsHello, I am using Calendar and I put into ny first column date but its not a wll order. I have July after June after July... Could you help meAnswered - Pending Review 13 views 3 comments 0 points Most recent by Andrée Starå Apps, Integrations, and Add Ons
-
Bar Chart is not scaling to include all dataIn Using SmartsheetI have a bar chart with 4 data points: 71, 3, 0, 2. The vertical axis is scaling 0 - 3.5, so it only fits the smaller numbers and it has no bar for the 71. It prints the number 71 under the horizontal axis labels, under the number 0. H…
-
Personal Report from multiple sheets with non-matching ColumnsIn Using SmartsheetI have a report created from two source sheets. Both source sheet columns match and the report is good. I can edit all the columns on the report. I have a third source sheet that I'd like to add to the same report. This third source sheet…
-
Multiple Criterion with Cross SheetsIn Formulas and FunctionsHello I am stumped. I have tried several different combinations to my formulas trying to get them to function. I get an #UNPARSEABLE error most of the time. I have tried this formula =COUNTIFS({Complete Claim Status}, [email protected], {Vendor N…
-
Using RIGHT/LEFT or FIND/REPLACE?In Formulas and FunctionsI thought that by using RIGHT and returning the values after ", " that it would fix the issue I'm having but depending on the difference in timestamps, I may get 7 or 8 characters so this formula doesn't work out for me. Would u…
-
Formula Criteria - IS ANY OF based on Multi-Select DropdownIn Formulas and FunctionsHey, So I'm going to guess that the answer is no, but I'm going to hope the answer is yes. We have a board that is used to help track hot or critical inbound items. The goal is to retrieve dates from our, lets call them 'Build Trackers', …
-
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
