## Forum Stats

• 38,176 Members
• 20,431 Discussions

# Recent Discussions

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

• Answered - Pending Review Kristin Badalow 12 views 5 comments Most recent by Paul Newcome Formulas and Functions
First post 04/20/20,Last post 04/20/20
Hello, Is there a way to return a date formatted column to an additional text column using formulas? I'm looking to create a report. It's not letting me use the "date" formatted field. That field needs to remain in date format, s…
Formulas and Functions125
• Accepted Answer Julie Still 11 views 10 comments Most recent by Paul Newcome Formulas and Functions
First post 04/20/20,Last post 04/20/20
https://us.v-cdn.net/6031209/uploads/368/4AAEHJ17LYDA.png I would like to add Red, Yellow and Green to help visualize how many days until the event has been closed.
Formulas and Functions1110
Julie Still
• BarneeL 563 views 10 comments Most recent by Kristin Badalow Formulas and Functions
First post 10/08/18,Last post 04/20/20
I would like to be able to use a formula to generate a date in a text field. However, when I try the formula, for example =TODAY() + 1 I get the error #INVALID COLUMN VALUE Is there a way I can convert this to text so I can I have it i…
Formulas and Functions56310
BarneeL
• Answered - Pending Review Kimberley Harris 14 views 4 comments Most recent by Paul Newcome Formulas and Functions
First post 04/20/20,Last post 04/20/20
Is there a way to autofill from one sheet to another. Example: I have data on one sheet and I am creating a % on another sheet. So I am linking the cells and dividing by a number in my % sheet. Is there a way to "drag" the data …
Formulas and Functions144
Kimberley Harris
• Answered - Pending Review gwson 37 views 6 comments Most recent by Darren M Premium Apps and Integrations
First post 02/28/20,Last post 04/20/20
How do I setup data uploader to update dropdowns in the contact list with NAME and Email. Right now it overrides the column property to the SINGLE DROPDOWN column and inserts email address only.
gwson
• Answered - Pending Review Amy Evans 34 views 3 comments Most recent by Paul Newcome Using Smartsheet
First post 04/20/20,Last post 04/20/20
Hello, I have a VlookUp question with 2 sheets. Sheet 1 has a simple table (see attachment) with Sizes and Hours. https://us.v-cdn.net/6031209/uploads/463/14G4L1ZWE4FD.png Sheet 2 - On another sheet, I want to executive a Vlookup and refe…
Using Smartsheet343
Amy Evans
• Answered - Pending Review Exxcellent 33 views 5 comments Most recent by Paul Newcome Formulas and Functions
First post 04/20/20,Last post 04/20/20
https://us.v-cdn.net/6031209/uploads/818/PPF0M31I24K7.png Hi, I need to use countifs to count the number of calls made to customers today. In my example, Touch 1 and Touch 2 are calls today, however I also need some filtering with user in…
Formulas and Functions335
Exxcellent
• Accepted Answer Sheanon Summers 26 views 4 comments Most recent by Sheanon Summers API & Developers
First post 04/18/20,Last post 04/20/20
Since Smartsheet doesn't have the option to resend update requests that haven't been completed, I wrote a script to pull all sent update requests, filter on pending requests, generate+send new requests, and delete the original request. Th…
API & Developers264
Sheanon Summers
• COUNTIF FormulaQuestion
Answered - Pending Review Kristina Kazakoff 11 views 3 comments Most recent by Paul Newcome Formulas and Functions
First post 04/20/20,Last post 04/20/20
I don't know why I'm getting zeros here. The reference sheet for Range 1 is a date column and Range 2 matches what is in the drop down menu. I also suspect that there's a more efficient formula to use - your feedback is welcome! https://us…
Formulas and Functions113
Kristina Kazakoff
• LouSnz 147 views 4 comments Most recent by Gabriel Toran Using Smartsheet
First post 05/20/18,Last post 04/20/20
Hello, is it possible to publish a dashboard and embed it into an email somehow?
Using Smartsheet1474
LouSnz
• Answered - Pending Review Richard Grimes 32 views 5 comments Most recent by Paul Newcome Formulas and Functions
First post 04/19/20,Last post 04/20/20
Hello, Please can someone help, I am using this formula to add one more criteria but it returns back saying #INVALID OPERATION, the formula works before i start using the AND to add the next criteria, and i cant see why? =SUMIFS({Cleani…
Formulas and Functions325
Richard Grimes
Accepted Answer James Moore 44 views 7 comments Most recent by Paul Newcome Formulas and Functions
First post 04/17/20,Last post 04/20/20
Is it possible to present a "Form" to a user, have them enter criteria. e.g. a unique customer number and then present other data to the user relating to that unique customer (e.g. the cust company name)? In other words, not prov…
Formulas and Functions447
James Moore
• Accepted Answer Karla George 23 views 3 comments Most recent by Paul Newcome Formulas and Functions
First post 04/13/20,Last post 04/20/20
I am trying to calculate employee utilization rates in smartsheet. I want to know the sum of individual employee effort (in percentage form) at any given given date in time. I have a list of current projects that has a line item for each…
Formulas and Functions233
Karla George
• Accepted Answer Tamara Sprung 34 views 8 comments Most recent by Andrée Starå Using Smartsheet
First post 04/17/20,Last post 04/20/20
I have an acct through my work. I actually have two accts. One I don't have the ability to make changes to a document unless the author gives me permission...nor do I have the ability to create a new doc. However...I do have the ability…
Using Smartsheet348
Tamara Sprung
• Answered - Pending Review Su Pi 13 views 7 comments Most recent by Andrée Starå Using Smartsheet
First post 04/17/20,Last post 04/20/20
I created a report that includes the "Sheet Name" column. The auto-generated links in this column go directly to the specific row on the sheet it's linking to. However, when I add the report as a widget on a dashboard, the links …
Using Smartsheet137
Su Pi
• Accepted Answer Corentin Dal Farra 12 views 6 comments Most recent by Paul Newcome Using Smartsheet
First post 04/20/20,Last post 04/20/20
Hello everyone, In smartsheet I tried to conifgure a workflow that launch an alert to a specific user. Does someone know if it is possible to configure an alert workflow that would be sent to someone according to his function or profil (fo…
Using Smartsheet126
Corentin Dal Farra
• Answered - Pending Review LLaCosta 11 views 4 comments Most recent by Paul Newcome Formulas and Functions
First post 04/16/20,Last post 04/20/20
We have (1) sheet that is used for basic data entry. No formulas or anything complicated. The user enters the date, start time, end time and categorizes the work they are doing by selecting a single category every task they complete. There…
Formulas and Functions114
LLaCosta
• Answered - Pending Review Rainier Hollands 21 views 5 comments Most recent by Paul Newcome Formulas and Functions
First post 04/16/20,Last post 04/20/20
Hi everyone, For my business I have multiple trucks, and every morning we record the statuses of the trucks before they start driving. I have multiple columns, each one being the different trucks. In the rows for those trucks I record the…
Formulas and Functions215
Rainier Hollands
• Answered - Pending Review Ashley Sabo 24 views 1 comment Most recent by Nathan Lloyd Premium Apps and Integrations
First post 04/17/20,Last post 04/20/20
Does anyone know if there is a way to export all workflows to identify which Salesforce fields are being used in the connector? Basically a map that identifies all the fields in Salesforce that Smartsheet touches and if its read only or re…
Ashley Sabo
• Accepted Answer Volson 44 views 3 comments Most recent by Genevieve P Formulas and Functions
First post 04/18/20,Last post 04/20/20
Hello - I am trying to sum a grant \$ amount when one column is marked "Yes" to COVID-19 Related and the other column is either marked "Approve" or "Approve-Repurpose". I can't seem to figure it out. Can som…
Formulas and Functions443
Volson
• Accepted Answer SteCoxy 23 views 7 comments Most recent by Paul Newcome Formulas and Functions
First post 04/16/20,Last post 04/20/20
Hello, I'm hoping someone may be able to help me with something that probably seems quite obvious or basic however, my knowledge on formulas or functions within Smartsheet is not advanced, so I apologise in advance! I'm trying to get my fi…
Formulas and Functions237
SteCoxy
• Accepted Answer sahilhq 13 views 1 comment Most recent by Paul Newcome Formulas and Functions
First post 04/18/20,Last post 04/20/20
Hey, Can anybody please suggest me with a formula that would calculate the average time a person takes to close an action assigned to him in a row? I have attached below the layout of the sheet. The formula should calculate the start of t…
Formulas and Functions131
sahilhq
• Answered - Pending Review Melisa Dannhauser 56 views 1 comment Most recent by Paul Newcome Formulas and Functions
First post 04/17/20,Last post 04/20/20
Hi, I'm trying to create a table that looks up data from a list of entries based on multiple criteria. I have been able to achieve PART of my task with different formulas but can't figure out how to achieve my desired end result. I tried I…
Formulas and Functions561
Melisa Dannhauser
• Grace 1.4K views 9 comments Most recent by Paul Newcome Formulas and Functions
First post 05/01/18,Last post 04/20/20
Hi all, I'm trying to get the count of active projects in my tracker sheet however I'm getting zero as a result. Please, can you check and advise what should be the correct formula? Here's the formula I used: =COUNTIFS(Stage:Stage, &quo…
Formulas and Functions14109
Grace
• Answered - Pending Review beatea 23 views 1 comment Most recent by Etienne Mermillod API & Developers
First post 04/19/20,Last post 04/20/20
It would be perfect if I cuold simply show the Smartsheet information inside of Confluence. No need for further fancy Jira/Confluence integration which I know costs a lot of money.
API & Developers231
beatea
• Accepted Answer m_dorsey 11 views 14 comments Most recent by Paul Newcome Formulas and Functions
First post 04/15/20,Last post 04/20/20
Hello, I'm trying to determine when to start a project based on the due date and the effort. The effort exists in hours and I've converted that into days based on a 7 hour day (padding days to allow for admin/other work in a day). This is …
Formulas and Functions1114
m_dorsey
• Answered - Pending Review Shirley Pruitt 32 views 10 comments Most recent by Paul Newcome Using Smartsheet
First post 04/17/20,Last post 04/20/20
Current Formula is working based on column "Scott Tomren Approval": =IF([Scott Tomren approval]1 = "Submitted", "Hold", IF([Scott Tomren approval]1 = "Approved", "Go", IF([Scott Tomren appr…
Using Smartsheet3210
Shirley Pruitt
• Alma PM 55 views 7 comments Most recent by Andrée Starå Using Smartsheet
First post 02/08/18,Last post 04/20/20
Hello everyone I would like to know if it is possible Check the Checkbox on multiple lines together
Using Smartsheet557
Alma PM
• Accepted Answer Katie White 44 views 5 comments Most recent by Darren Richardson Formulas and Functions
First post 02/28/20,Last post 04/20/20
Can someone help point me in the right direction of where to go to submit a ticket for this? For four rows on my sheet (Row 1, 3, 4, 5) every time I save my sheet those rows update the modified date, even though I'm not touching those rows…
Formulas and Functions445
Katie White
• J. Craig Williams 35 views 4 comments Most recent by Jinn Luu Formulas and Functions
First post 02/18/18,Last post 04/20/20
A Viewer has little reason to need to see a formula in a column that is being displayed to them in a Report. Please remove the hover for the Formula (the other hover that displays the full contents (display value) of the cell is OK, just …
Formulas and Functions354
J. Craig Williams