or Explore Discussions

# Solution Center

## Discussion List

• ADD 3WEEKS, , 2WEEKS, 1WEEK AND 24 HOURS DATE
In Formulas and Functions
I need a formula that calculates 3weeks date, 2 weeks date, 1 week date and 24 hours date from a due for each column where the due date is another sheet. Let's say column Citrix status in another sheet is feb/3/22, so under Citrix Status 3…
Unresolved
20 2
Question 20 views 2 comments Most recent by Rob_PM Formulas and Functions
• Pulling data into a "master sheet"
In Formulas and Functions
Hello all, I am trying to pull select data from multiple sheets into one "master sheet", however I am struggling to find a working method. I am unable to use reports due to them not connecting with datashuttle. I have tried VLOOK…
15 1
Answered - Pending Review 15 views 1 comment Most recent by Genevieve P. Formulas and Functions
• Survey Help!
In Using Smartsheet
Hello All! I need your help! I need to send out a survey via email where I need employees to rank 10 different topics in a 1-10 format.
Accepted
19 1
Accepted Answer 19 views 1 comment Most recent by Genevieve P. Using Smartsheet
• Is there a work around for trying to use CONTAINS() or HAS() within collect()?
In Formulas and Functions
I am trying to summarize my projects data that is assigned to a work type, dates/weeks specifically and then count it by week or singe day. Can't figure it out. I have a summary sheet that brings in a multi select column (I have also tri…
Accepted
19 3
Accepted Answer 19 views 3 comments Most recent by Greg F Formulas and Functions
• How can I count distinct values under a same month?
In Formulas and Functions
Hi everyone, I currently have a data set for which I would like to count all unique values that are under a same month and a same year. For example, the following table shows two duplicate values (TR ID's) on two different dates. In this …
100 3
Answered - Pending Review 100 views 3 comments Most recent by Genevieve P. Formulas and Functions
• Indenting on smartsheet causing calculation error- help?
In Formulas and Functions
Hello, My organization uses smartsheet as a scheduling tool. We have a column that calculates what resource hours we have remaining for available scheduling (formula =((# of crew members * work days * work hours) - SUM(CHILDREN())) in my …
Accepted
13 3
Accepted Answer 13 views 3 comments Most recent by Heather Duff Formulas and Functions
• Form - Copy of Answers
In Using Smartsheet
Hello, Is it possible for a form submitter to receive not just their answers, but also a copy of what they filled out? Our form has information in the question descriptions (not just the Q&A fields) that we'd like them to have a copy o…
14 1
Answered - Pending Review 14 views 1 comment Most recent by Andrée Starå Using Smartsheet
• Removing Rows at Bottom of Sheet - Affecting Formulas on Dashboard
In Formulas and Functions
There are about 10 blank rows at the bottom of my sheet that keep coming back, even after I delete them. I either need to know how to permanently delete them or how to adjust my formulas to not include them because they are affecting our d…
170 5
170 views 5 comments Most recent by Shile Formulas and Functions
• Extract multiple pieces of a text string that meet a criteria - between parentheses
In Formulas and Functions
I want to extract both the 1234 and 4567 from this text string: "First set of data to extract between parentheses (1234) and second set of data to extract between parentheses (4567) and that is it" I am able to pull the 1234 wi…
Accepted
32 10
Accepted Answer 32 views 10 comments Most recent by Paul Newcome Formulas and Functions