functionality
Discussion List
-
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 …
-
Using COUNTIFS with CONTAINSIn Formulas and FunctionsHello, I have a contact column where some rows have more than one person assigned to a task. I want to count the number of tasks assigned to any given individual. This is the formula that I have created to do this: =COUNTIF(CONTAINS("…Accepted Answer 2.4K views 14 comments 0 points Most recent by Chris Grinstead Formulas and Functions
-
Smartsheet - Logging me out / Closing while workingIn Using SmartsheetSmartsheet is logging me out / closing while I'm working on it. I have submitted a support ticket, but have not received any response or feedback. Is anyone else experiencing this issue? It seems similar to the issue that happened on 1…
-
Dashboard with Filters - Best PracticeIn Formulas and FunctionsHi all, I am pretty new to Smartsheet and will need your help to build a dashboard. What is the best practice to create one? GRID I have multiple salespeople in my team, each of them have their own grid. The grid looks something like this…
-
How to create a top five.In Using SmartsheetHi! I've working on a dataset for a while now that essencially logs the everyday orders we receive from our clients. One of the colums records the name of the customer and I've been trying to create a report that counts how many orders a …
-
Cross Sheet Joining AutomationIn Formulas and FunctionsHello Community, I am attempting to make a few helper sheets try to consolidate information into one row. Background: I have multiple sheets that have hundreds of parts/items from a range of vendors. I am hoping to implement a checkbox th…
-
How record a date automation work?In Using SmartsheetHi, I'm having trouble using the record a date automation. as you can see in 1st picture, I create record a date when "send noti to slack" is checked in 2nd picture, every change I made in that check box is from 25-Nov-2021 but r…
-
Trying to find a way to update information on existing rows via a form (not via update request)In Using SmartsheetHello Smartsheet Community. I have a customer who has uploaded an existing excel spreadsheet into Smartsheet (about 200 rows) which includes information such as email address, first name, last name, etc. as columns. We have created a form …
-
Customized button text not reflecting on approval workflowIn Using SmartsheetHi, When we customize the button text under 'Approval Workflow' it still shows default values i.e. 'Approve' and 'Decline'. Is there any workaround available.
-
Is that possible that Smartsheet automatically writes hierarchy numbers for tasks level ?In Formulas and Functions
