Travis Employee

Overview

Overview

Roles	EmployeeMember
Badges	30

About Me

About Me

Area of Expertise	Web Forms
About Me	I am an East Coast native loving my work at Smartsheet in the sunny Pacific North West
How I Use Smartsheet	In my personal life I use Smartsheet to track everything from my home-brew schedule, recipes (ask me about my recipe sheet!), and to do lists.

Analytics

2,016

Posts

1

Visits

161

Points

Feb 10, 2015

Join Date

Jan 21, 2020

Last Active

Reactions

• Promote 1

  1
• Insightful 10

  10
• Vote Up 62

  62
• Awesome 4

  4

• Activity
• Discussions12
• Comments2K

• Re: Discussions - Allow html and embedded images

  Travis

  05/20/16
  Good suggestion! I will add your vote for this request and it will be considered for future development. 
  1 ·

• Re: Update a Status Column when % Complete

  Travis

  10/05/15
  Try this: =IF([% Complete]6 = 0, "Not Started", IF(AND([% Complete]6 > 0, [% Complete]6 < 1), "In Progress", IF([% Complete]6 = 1, "Completed")))
  1 ·

• Re: Using SUMIF when column is not blank

  Travis

  03/07/16
  You wont be able to say "not blank" in a SUMIF but you can SUMIF it is blank, then subtrack that from the total SUM. Try this: =SUM(CHILDREN(Amount25)) - SUMIF(CHILDREN([Date Paid]25), &quo…
  1 ·

• Re: Hours NOT adding up to correct number of days

  Travis

  08/04/15
  Hi Cris, parent row duration is not a SUM of child row durations, but rather the duration between the parent row Start and End date which are taken from child row dates/durations. It looks like these…
  1 ·

• Re: Status Symbols (traffic lights)

  Travis

  07/24/15
  Hi Grace - good suggestion, I will submit this to the product team! One option is to use conditional formatting to color the RYGB box if your task has not started. This means you could have a rule th…
  1 ·

Previous Next