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
-
Calculate % on time deliveries for teamIn Formulas and FunctionsHi, I was able to use the following formula to count the % of on-time deliveries per team member. =COUNTIFS([Work Days Between Due date and Date sent]:[Work Days Between Due date and Date sent], <=1, Reviewer:Reviewer, "ABC"…
-
Referencing an entire column from another sheetIn Formulas and FunctionsHello, I am working on a cross-sheet formula. The ultimate goal is to write something that says this: If room column on [Sheet 2] contains "room name" AND (date on [Sheet 1] falls between Check in Date and Check Out Date on [She…
-
Formula needed for IF functionIn Formulas and FunctionsI need a formula to say if a certain cell's number is less than 1, then another cell equals 135, and if that same cell's range 1-2, then another cell equals 225, and so on. My ranges are: <1 = $135 1-2 = $225 2-9 = $90 10-19 = $72 20-2…
-
Dynamically Customize Alert and Request Messages with PlaceholdersIn AnnouncementsType double-curly brackets around the column name {{column name}} in the subject or body, along with any other desired text, when typing a custom alert message—either at the time of creating an alert rule or while editing an existing one. …
-
COUNTIF in Sheet Summary counting things that are not thereIn Formulas and FunctionsI am a formula novice and I am trying to count the number of instances certain criteria show up in a column. I noticed that it is counting extra things. For example, I know that it should add up to 6, but it is counting 3 extra things that…Answered - Pending Review 12 views 1 comment 0 points Most recent by Andrée Starå Formulas and Functions
-
Ability to create folders in the attachments tabIn Using SmartsheetIs there a way to create a folder in an attachments tab? We have versions of image files we want to see but would like to be able to create a folder for 'old photos' or something like that within the attachments tab to help sort/seg the a…
-
Populate a STATIC Date column based on another column in sheetIn Using SmartsheetHi there, I am trying to set a date based on when another status column is set to a desired value. For instance, I want to populate a start date (which will never be changed). with the date that the Request Status is set to "Ready Fo…
-
Issue with Linking out to other sheets in our workspaceIn Formulas and FunctionsI have had a problem today trying to create a link a cell to another sheet. When we try to create the link there is an error message; (Image) I have tried logging in and out again. both sheets are in the same workspace and there are simila…Answered - Pending Review 2 views 3 comments 0 points Most recent by Andrée Starå Formulas and Functions
-
Multiselect to single line itemIn Formulas and FunctionsGood Afternoon, I am looking to separate a client into their individual renewals from a master sheet that has the client renewal dates in a multi-select drop down: Live Clients List: Client Name Renewal Month …Answered - Pending Review 22 views 4 comments 0 points Most recent by Sandi Cervantes Formulas and Functions
-
Outlook Add-InIn Using SmartsheetHow come there is only a start date when you create a task from outlook? Due date is greyed out.
