## 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

• Announcement Genevieve P. 516 views 21 comments Most recent by Andrée Starå Welcome to the Community
First post 12/11/19,Last post 01/16/20
Welcome to the Smartsheet Online Community!  Here in the Community, you can interact with other Smartsheet customers to get help and share best practices.  All posts and comments are monitored by Smartsheet employees, our moderators, to e…
Welcome to the Community51621
Genevieve P.
• Ray B 5 views 2 comments Most recent by Ray B Formulas and Functions
First post 01/25/20,Last post 01/25/20
Good evening Smartsheet Community: I trying to create a formula that would give me the Number of Done in the Status Column based on Today's Date so I can see at any given time how many issues are done. If anyone has a similar formula they …
Formulas and Functions52
Ray B
• Answered Leann Gibson 24 views 2 comments Most recent by Melanie Kourbage Formulas and Functions
First post 01/16/20,Last post 01/25/20
Does anyone know why I am getting this message "Cannot add this user to this group"? I created the group, however it is not letting me add everyone I need to.
Formulas and Functions242
Leann Gibson
• Question Ray B 2 views 0 comments Started by Ray B Formulas and Functions
First post 01/25/20,Last post 01/25/20
Does anyone have a variance Formula between 2 dates that only counts the weekdays and not the weekends? Here is my Current Formula which Counts All 7 Days: =IF(ISBLANK([Finish Date (Actual)]@row), "", IF(AND(ISBLANK([Finish Date …
Formulas and Functions20
Ray B
• Answered Arianna Pulidori 9 views 2 comments Most recent by Arianna Pulidori Formulas and Functions
First post 01/24/20,Last post 01/25/20
Hi All, Does anyone know if there is a way to use VLookup with values selected from a DropDown with multiple selection? This is my example: I have a grid with all contacts dived by studios. https://us.v-cdn.net/6031209/uploads/090/3OLS99…
Formulas and Functions92
Arianna Pulidori
• Question Paola Barlow, PMP 4 views 0 comments Started by Paola Barlow, PMP Using Smartsheet
First post 01/25/20,Last post 01/25/20
Is Smartsheet Gov compliant with ADA section 508?
Using Smartsheet40
Paola Barlow, PMP
• Answered Steve Schroeder 5 views 1 comment Most recent by Steve Schroeder Using Smartsheet
First post 01/24/20,Last post 01/25/20
I created a sheet in Grid view for projects I'm managing. It has start and finish date columns, along with task names, etc. I've done some copying and pasting to put tasks in there. When I click on gantt view, only a handful of tasks sh…
Using Smartsheet51
Steve Schroeder
• Carly Sorensen 142 views 4 comments Most recent by Chris Kalaras Using Smartsheet
First post 05/31/18,Last post 01/24/20
I understand there is no way to link directly to a file from dashboard unless it is in a cloud-based storage program. Has anyone found a workaround? We don't use this kind of storage and I want to be able to link directly to files.  Savin…
Using Smartsheet1424
Carly Sorensen
• 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