Discussion List

• Formula to calculate End Date and Time based on Start Date, Time and Task duration

  In Formulas and Functions

  Hello, I'm looking for a formula to calculate the End Date and Time (MM/DD/YYYY)( HH:MM AM/PM) based on the Start Date and Start Time entered on a form using the Task standard routing time.

  Shanelle

  05/12/22

  Accepted

  1933 32

  Answered ✓ 1.9K views 32 comments 0 points Most recent by mukul 05/12/22Formulas and Functions
• Can I populate Smartsheet rows from a SQL Database read?

  In API & Developers

  I have data on Snowflake data warehouse and also on a SQL server table. Does Smartsheet support connection to Snowflake or SQL database to read data and populate rows on a Smartsheet?

  Senthil Anandarangan

  04/20/22

  Answered - Pending Review

  2158 8

  Answered - Pending Review 2.2K views 8 comments 0 points Most recent by Richard Rymill SBP 04/20/22API & Developers
• Invoice & Budget Tracking for Construction Projects - using Attachments

  In Using Smartsheet

  This is an easy way to keep track of your invoices

  Thai La

  08/24/21

  303 2

  303 views 2 comments 1 point Most recent by W. Chad McPhail 08/24/21Using Smartsheet
• Extract Image using Index and Match/Vlookup

  In Formulas and Functions

  Hey All - Does this exist yet? See screenshots below. Am i missing a piece in the formula? Or is my column type incorrect? I cant seem to find an article on this. I know its a bit tricky to do this in excel too - and their version doesn't…

  Julia Mazza

  06/14/21

  Accepted

  383 3

  Answered ✓ 383 views 3 comments 1 point Most recent by Julia Mazza 06/14/21Formulas and Functions
• Tracking Employee Training and Certifications

  In Using Smartsheet

  Hello! We are trying to find the best way to track employee training and certifications categorized by department and type of position. Has anyone been working on anything similar that they could share? TiA!

  Michael Maxson

  03/25/21

  Accepted

  1402 4

  Answered ✓ 1.4K views 4 comments 1 point Most recent by Andrée Starå 03/25/21Using Smartsheet
• Automation 'Copy to another sheet' doesn't work

  In Formulas and Functions

  I have set up an automation rule to, when triggered, copy rows to another sheet. My trigger is a certain field that changes from 0 to 1. I've tried a couple of times and non of my rows are copied. To test it, I added to the same automatio…

  Stelina Todorova

  01/15/21

  Accepted

  1796 16

  Answered ✓ 1.8K views 16 comments 0 points Most recent by Christina.R 01/15/21Formulas and Functions
• Populating external Reports with Smartsheet Data

  In Using Smartsheet

  Hi, Is there any way that I can export my data from smartsheet so that it automatically populates/merges into a template that i have (word document) Thanks in advance, Scott

  Scott Rae

  01/04/21

  Accepted

  65 6

  Answered ✓ 65 views 6 comments 0 points Most recent by Andrée Starå 01/04/21Using Smartsheet
• Date updating to Next Day using Index, Match, Max, Collect Formula

  In Formulas and Functions

  Hi, I'm working with two Smartsheets. (1) One sheet collects the data from a Smartsheet form. I added two columns to this sheet using the Auto-Number/System Feature (under Edit Column Properties). This features stamps new row entries wit…

  Amy Arnold

  11/09/20

  Answered - Pending Review

  310 4

  Answered - Pending Review 310 views 4 comments 0 points Most recent by Robin Poppsinger 11/09/20Formulas and Functions
• Simplest way to update staff on onboarding tasks

  In Formulas and Functions

  My organization (a small physicians office) is creating a new onboarding check list via smartsheet. We want to update the staff on certain tasks they need to complete for new staff members going through the process. I've considered a few o…

  Zachary Mitchell

  09/22/20

  Answered - Pending Review

  116 3

  Answered - Pending Review 116 views 3 comments 0 points Most recent by Brianne Laird 09/22/20Formulas and Functions