or Explore Discussions

# industry

## Discussion List

• Smartsheet and Procore Integration
In Formulas and Functions
Has anyone used Smartsheet hand in hand with Procore? Background: My company is the design team on a construction project. We are using Smartsheet to handle workflows and documents questions from our subcontractor. The subcontractor is …
94 2
Answered - Pending Review 94 views 2 comments Most recent by Andrée Starå Formulas and Functions
• How are you using Smartsheet to help you homeschool during COVID-19 closures?
In Staying on the Same Sheet
We've been celebrating the social distancing brought on by mandatory office closures and work from home has been great! Meaningless meetings have been cancelled. Chatty Kathy hasn't been stopping by our desks with distractions four times p…
3519 14
3.5K views 14 comments Most recent by Miaenn Staying on the Same Sheet
• How can I automate a subtraction
In Formulas and Functions
Hey, How can I subtract a number from the total each time a row is added. I have an Inventory sheet that linked to another sheet. for example, in the picture below; how do I subtract a Number of Machine each time a row is added? Thanks i…
Accepted
1669 16
Answered ✓ 1.7K views 16 comments Most recent by Paul Newcome Formulas and Functions
• Local Government Uses
In Using Smartsheet
I am a Mayor of the city in Washington. We are looking at Smartsheet to add as a project management tool for staff. I am interested in how other local governments are using Smartsheet? Specific areas of interest are Capital Projects, H…
94 0
94 views 0 comments Started by Brett Gailey Using Smartsheet
• How to if statement for more than one cell ?
In Formulas and Functions
How to if statement for more than one cell ? What I have is three cells with dates and I want the sheet to check if there is a date in the 3rd cell to count from that date if not to check the second and if not to check the first cell
Accepted
35 11
Answered ✓ 35 views 11 comments Most recent by Paul Newcome Formulas and Functions
• Multiple conditions (from different columns) applying conditional formatting
In Formulas and Functions
1 Can I do conditional formating using more than one criteria (different Columns) We track goals for residents and if the goal is not met within the required timeline I would like it to highlight the total in red. is there a way to make 2 …
2149 3
Answered - Pending Review 2.1K views 3 comments Most recent by Andrée Starå Formulas and Functions
• Help with SUMIFS formula to display todays census
In Formulas and Functions
Hello, Every day three service line VPs complete a SS Form. The form's information indicates todays date, service line, and a census. I need a formula (I presume =SUMIFS) that tells me the census for one of those service lines for only 'to…
42 3
Answered - Pending Review 42 views 3 comments Most recent by Andrée Starå Formulas and Functions
• Backup tool for one user only?
In API & Developers
I am using the backup tool provided through the below link with SmartSheet. The issue we are running into is that we do not need it to backup every single user (this is time consuming and bloats to over 3 gigs of data currently). We are …
Accepted
42 7
Answered ✓ 42 views 7 comments Most recent by Timothy French API & Developers
• Return Same Vlookup for certain day.
In Formulas and Functions
Basically what im trying to do is a project tracker. When the guys do a project they spend a certain amount of hours on it. thats all good until the project is paused and restarted again i have a issue where it calculates off the closest d…
Accepted
131 5
Answered ✓ 131 views 5 comments Most recent by Cary S. Formulas and Functions
• Need help with creating aging buckets.
In Formulas and Functions
Hello, I have the following formula in excel but it did not transfer to Smartsheet. Is there a way to get this formula over? =LOOKUP(F2,{-100,7,14,21,30,45,90,180},{"0-7","7-14","14-21","21-30",&quo…
Accepted
1203 2
Answered ✓ 1.2K views 2 comments Most recent by Debbie Sawyer Formulas and Functions