-
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
-
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?
-
Splitting Update Request
So, we send out quarterly update requests to various different departments...more specifically, to named individuals within those departments whose details are held within a Contacts column. These updates are timed so that they automatically go out a number of days before a data entry deadline. Due to the variation in data…
-
Report Stopped sorting alphabetically
Hi, I'm having problems sorting my report alphabetically. It was working fine before but now i cant sort by the names of the assigned to alphabetically and i'm hoping someone can help me with this. I've tried creating a new report and i'm getting the same result. Thank you!
