Formulas
Discussion List
- Hello again! I have been trying to figure out a formula for averaging the remaining. This sheet has all business days through Dec 8 and a certain number of tasks to complete each day to be finished on…
- I use Smartsheet to track employee certifications. I'd like to determine the average number of certifications per person at each site/area. I'm able to use an equation to determine the number of certi…
- I'm trying to find a solution to reduce the number of updates my team and I have to do. We currently use Smartsheet to create and manage project plans but also have a master "Status Sheet" that lists …
- We use Smartsheet for our production schedule. The schedule consists of 9 sheets that are all in a workgroup. Is it possible to setup a rule that would allow a row from one sheet to be moved to anothe…
- I've noticed that to have the "% complete" column value show up graphically within the Gantt display, the "% complete" column MUST be a free-form entry field. I have another sheet column that uses the…
- I find the value of Smartsheets to be the card view. I almost exclusively work in card view, and routinely add new items by adding new cards. There are several fields that contain formulas. Until toda…
- Hi EVeryone- I have a sheet which contains the lookup values to my master sheet, and I have created a few datamesh lookup rules which works well, but if a new row gets added to my master sheet, I need…
- I have a due date column that I am trying to return a specific value from.My fiscal year runs from 10/1/17 through 9/30/18. Is there a formula that I can write that would pull the fiscal year and mont…
- Good Day All: I would like a cell to change color (background color) based on a range(See Below). Has anyone used such a formula? My Sheet: https://app.smartsheet.com/b/publish?EQBCT=906e1a0d8f8342e4b…
- In my sheet I have a list of projects with various statuses and I need to do summary numbers by month and reduce the number of statuses to 2 (scheduled and unscheduled). I know how to do this if I use…