## Forum Stats

• 33,414 Members
• 17,335 Discussions

#### Welcome to the New Smartsheet Online Community

You’ll notice that things have changed a bit. If you need help getting oriented, please take a look at the posts here in the Welcome to the Community category.

# 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 Joanie Velles 9 views 1 comment Most recent by Joanie Velles Formulas and Functions
First post 01/24/20,Last post 01/24/20
Hello, I am trying to run a SUMIF formula off of a different Smartsheet using the person in the contact lists formula. I've created the SUMIF Formula below, but it is not totaling the FTE column (Range 4). If someone could please advise, …
Formulas and Functions91
Joanie Velles
• Answered mschlaudraff 3 views 1 comment Most recent by Helm Using Smartsheet
First post 01/24/20,Last post 01/24/20
Back in December I had a meeting with the Pro Desk, and one of the items we talked about was the multi-select mapping with Jira Multi-select fields via Jira Connector. I was informed that the Product and Dev Team where working on support t…
Using Smartsheet31
mschlaudraff
• Nathalie DeAngelis 13 views 5 comments Most recent by Nathalie DeAngelis Formulas and Functions
First post 01/24/20,Last post 01/24/20
This is my formula: =IF(Staff4 <> "", VLOOKUP(Staff4, {Sheet - PTO & Project Staffing Range 1}, 56, false), "") I need to see all the data in Staffing Range that Staff4 is working on. https://us.v-cdn.net/6031…
Formulas and Functions135
Nathalie DeAngelis
• Accepted Answer Art Miller 8 views 1 comment Most recent by Art Miller Formulas and Functions
First post 01/24/20,Last post 01/24/20
Hello, Creating a dashboard with one source sheet and want to show the latest date when any row is modified in the sheet. Easy to select just one cell to represent this with the metric widget. However I need a formula that will pull th…
Formulas and Functions81
Art Miller
• adgcz 16 views 4 comments Most recent by SnackyPete API & Developers
First post 05/21/18,Last post 01/24/20
Dear Smartsheet, The issue - import of a google/excel sheet containing an "Assigned To" column fails to assign to known smartsheet users any of the tasks listed in the file that was imported with matching user names/email addre…
API & Developers164
• Accepted Answer Tanya Boehmke 13 views 19 comments Most recent by Tanya Boehmke Formulas and Functions
First post 01/24/20,Last post 01/24/20
Hello, I've determined the issue with this formula is that the cell it is pulling from is formatted as text, not a number. I know I need to use the VALUE function to correct this, but I've tried this many different ways and cannot get it t…
Formulas and Functions1319
Tanya Boehmke
• Question mschlaudraff 7 views 0 comments Started by mschlaudraff Using Smartsheet
First post 01/24/20,Last post 01/24/20
Ok, So I'm trying to use these new workflow ( https://help.smartsheet.com/articles/2479626-automatically-move-or-copy-rows-between-sheets ) and I'm running into an issue... So I'm in the sheet I need to copy from, and I create the workflow…
Using Smartsheet70
mschlaudraff
• Question Paola Barlow, PMP 5 views 0 comments Started by Paola Barlow, PMP Using Smartsheet
First post 01/24/20,Last post 01/24/20
Hello guys, Can anyone confirm if proofing is supported by Smartsheet Gov? Thanks, Pao.
Using Smartsheet50
Paola Barlow, PMP
• Answered mmac 28 views 2 comments Most recent by mmac Formulas and Functions
First post 01/22/20,Last post 01/24/20
Hello, I'm looking to accomplish the following and am hopeful that someone will be able to help support. Thank you in advance. Working with the following columns: Start Date End Date Sale Status Assignee QA Status Scenarios: If a sale…
Formulas and Functions282
mmac
• Question Shawn Fritz 8 views 0 comments Started by Shawn Fritz Using Smartsheet
First post 01/24/20,Last post 01/24/20
I have an approval workflow that will send a follow up email to specified recipients if approved or declined. The problem is that attachments are not being included with these emails. Is this by design?
Using Smartsheet80
Shawn Fritz
• Accepted Answer Angela Ryer 38 views 12 comments Most recent by Paul Newcome Formulas and Functions
First post 01/17/20,Last post 01/24/20
=IF(Status6 = "Open", IF([Due Date]6 <= TODAY(2), 1, 0), (IF([Send to High Risk Report Now]6 = 1, 1, 0))) https://us.v-cdn.net/6031209/uploads/777/529C59A6UPMV.png I have this formula that each IF function works on its own, b…
Formulas and Functions3812
Angela Ryer
• Question Donni Matthew 8 views 0 comments Started by Donni Matthew Premium Apps and Integrations
First post 01/24/20,Last post 01/24/20
We have seen two issues in Dynamic View that I am wondering if there is a solution I haven't thought of. When I add an attachment to a row in my sheet; in Dynamic View, I cannot see the attachment. Is that expected behavior? When I uplo…
Donni Matthew
• Question M. David 6 views 0 comments Started by M. David Formulas and Functions
First post 01/24/20,Last post 01/24/20
I would like to enter a formula into Sheet Summary that will show the last time a sheet was edited by a specific person. That person is identified on every row in an "Assigned To" column. I have both the Modified and Modified By …
Formulas and Functions60
M. David
• Question Bruce Reynolds 5 views 0 comments Started by Bruce Reynolds Using Smartsheet
First post 01/24/20,Last post 01/24/20
is it possible to send out a reminder email at 3pm for Mon-Fri and the same reminder to the same people but at 7am on Saturday and Sunday?
Using Smartsheet50
Bruce Reynolds
• Question smarterppsd 10 views 0 comments Started by smarterppsd Formulas and Functions
First post 01/24/20,Last post 01/24/20
I'm trying to set up a ticket system and having a little trouble figuring out how to accomplish my goal. Technicians have their own sheets and forms to submit updates on their tickets. Multiple techs can work on the same ticket ID. Their …
Formulas and Functions100
smarterppsd
• Answered Terry Ables 35 views 3 comments Most recent by Terry Ables Formulas and Functions
First post 01/21/20,Last post 01/24/20
I'm trying have have my rows automatically update priority while allowing the user to move the rows to arrange their desired priority order. Its all working good with the exception if i move the first row or try to move another row as the…
Formulas and Functions353
Terry Ables
• Accepted Answer Mary Smith 15 views 3 comments Most recent by Mary Smith Formulas and Functions
First post 01/24/20,Last post 01/24/20
Hi there! I have the following columns: Actual Invoice Date, Due Date, Invoice Status and, Days Past Due. First, I'd like to have the Invoice Status display SENT if there is a date present the Invoice Date column and then have it display P…
Formulas and Functions153
Mary Smith
• Tom.Richards 41 views 7 comments Most recent by Paul Newcome Using Smartsheet
First post 01/17/20,Last post 01/24/20
New user looking for some advice. We need to: Capture requests from a form(s) and save the original data. We know comments and attachments will be made by other users, and we don't want them to mess up what was originally there, or the or…
Using Smartsheet417
Tom.Richards
• Question Yogin Bhatti 6 views 0 comments Started by Yogin Bhatti Formulas and Functions
First post 01/24/20,Last post 01/24/20
Hello SS Community, I'm trying to count the number of instances two values appear together in a cell. From the following example, I would like to count how often "Contractor" and "Vendor" appear together, and furthermo…
Formulas and Functions60
Yogin Bhatti
• Accepted Answer Lee Ratzlaff 8 views 4 comments Most recent by Lee Ratzlaff Formulas and Functions
First post 01/24/20,Last post 01/24/20
Hello! I am trying to create an IF statement to show the federal fiscal quarter an event occurred. Could someone please help troubleshoot my syntax? Federal Quarters: Q1: Oct, Nov, Dec (10, 11, 12) Q2: 1, 2, 3 Q3: 4, 5, 6 Q4: 7, 8, 9 Not …
Formulas and Functions84
Lee Ratzlaff
• Answered MCorbin 6 views 1 comment Most recent by [email protected] Formulas and Functions
First post 01/24/20,Last post 01/24/20
I have a formula that is pulling a status update from 3 different sheets: =IFERROR("BA: " + INDEX({ITBA Status}, MATCH(\$[Project / Task ID]@row, {ITBA PID}, 0)), "") + IFERROR(" AppDev: " + INDEX({Dev Status},…
Formulas and Functions61
MCorbin
• Accepted Answer Robyn Pier 52 views 22 comments Most recent by Robyn Pier Using Smartsheet
First post 12/16/19,Last post 01/24/20
Hi I need to allow my team to update nursing visit dates on existing patients. I have read that I can't use a form to do so. I can't really use an update request because I don't know when the changes are going to take place. Is there an…
Using Smartsheet5222
Robyn Pier
• Accepted Answer ALAIN-STEPHANE 31 views 13 comments Most recent by Paul Newcome Using Smartsheet
First post 01/21/20,Last post 01/24/20
Hello , Does " Automatic numbering for Work Breakdown Structure " exist in SMARTSHEET ? It's been a couple of days now that I am searching for . Can someone help me ?
Using Smartsheet3113
ALAIN-STEPHANE
• mschwahn 129 views 9 comments Most recent by Victoria Cervantes API & Developers
First post 10/21/19,Last post 01/24/20
When dragging the email from my Outlook window to Smartsheet in Google Chrome it removes the file from my Outlook entirely and the email is gone. I tested this in MS Edge and confirmed it does not happen when using Edge; the file copies a…
API & Developers1299
mschwahn
• Answered Robyn Pier 7 views 4 comments Most recent by Robyn Pier Formulas and Functions
First post 01/24/20,Last post 01/24/20
I can't find a formula that works to do a tally of how many patients I had in each month. Would I do a COUNT and then somehow determine it by month? Help please??? :)
Formulas and Functions74
Robyn Pier
• Question Sarah Krueger 4 views 0 comments Started by Sarah Krueger Using Smartsheet
First post 01/24/20,Last post 01/24/20
I want to integrate Smartsheet with Outlook. Is there a workaround for this error?
Using Smartsheet40
Sarah Krueger
• Answered JPJ 8 views 7 comments Most recent by JPJ Formulas and Functions
First post 01/24/20,Last post 01/24/20
Hi I have a countif formula =COUNTIF(Wed10:Wed51, "HPT" to count the number of times HPT shows in a column. I want to format the result by color compared to another cell. For example: i need 5 however; the countif returns 4(count…
Formulas and Functions87
JPJ
• Answered Jenna Corso 12 views 2 comments Most recent by Jenna Corso Formulas and Functions
First post 01/24/20,Last post 01/24/20
Hello, I'm trying to count the number of cells that have a date in the year 2020. This is the formula that is returning "0" which is incorrect: =COUNTIFS([Column 1]:[Column 1], <=DATE(2020, 12, 31), [Column 1]:[Column 1], &g…
Formulas and Functions122
Jenna Corso
• Answered Fabien Videotron 22 views 1 comment Most recent by Ella Premium Apps and Integrations
First post 01/21/20,Last post 01/24/20
In Datamesh, when the lookup value in the target sheet is blanked out (delete) or even changed to a value that has no match in the source sheet, all the mapped columns in the target sheet remain with the previous value which makes the data…