-
Battle over Sorting and Filters
Greetings, We are starting to use Smartsheet heavily in a lot of our processes. We deal with contractors on a daily basis. We have several groups of contractors that view one master sheet and each of their own set of columns they review and work with. They may not directly interact with other parts of the master sheet, but…
-
Being able to choose multiple choice in dropdown list
Hello everyone - I am trying to have it so that I can choose multiple options in a dropdown menu for a cell. Or someway that I can have a list of things in a cell. It is for tracking blog post categories. Thanks - Carlyle
-
CONDITIONAL FORMATTING FOR DATE TYPE CELL
Greetings I need to apply conditional formatting to a date type cell. I need to write a formula such that, when a the target number for a certain task has been reached, the deadlines for the next target has to be set. For Example, if the target for task A has reached today, then the start date for the next task should be…
-
purchase order
I'm new user of Smartsheet, I want to create new purchase order but I can't find any template. need help pleas !!! thank you
-
RYG Balls past start date with a complete box
I am trying to automate the ryg ball if i go: 15 days past start date and my complete is blank, red ball 10 days past start date and complete is blank, yellow ball otherwise green ball. Any help is appreciated
-
Smartsheet Referral Program
Hi, Wanted to check if smartsheet has any referral program (where existing user introduces new users) ? If yes, how does the same work ? Have tried checking the app but unfortunately couldnt find any such information pertaining to referrals there. However there is a Smartsheet Referral Agreement available on web thus not…
-
How to eliminate Divide by Zero error from IF formula
I have a "Divide by Zero" error that I can't seem to get rid of. =IF(Percentage3 = "overstaffed", [Column8]3 / Ordered3, Received3 / Ordered3) Not sure where to place the IFERROR into this formula to ensure that I don't get the error to pop up.
-
Project Completed If Date Entered
Hi, I am trying to extract a confirmation from a row containing dates. The objective of the following formula is to determine if a date has been entered and if so, display the number 1. If not, to Display a zero. Note, the formula works when information is not entered in to a DATE column, however when the cell is blank, it…
-
Summarizing from multiple sheets (count, drilling down, etc.)
I've been searching the Community section but am having a hard time finding the exact answer I'm looking for, so I hope someone can help. I haven't worked with Reports or Dashboards before, so I'm just not sure exactly how to set up my sheets for this new project. My company is conducting reviews of our office locations a…
-
RYG results are different
For RYG indicators I am using the same formula for all rows in my sheet but as you can see from my screenshot some rows have different results. Dates are the same, status and % complete are the same. How is it possible to have different results?