-
Task bar conditional formatting for calendar view (non defined task lengths)?
Hi guys I'm trialling out smartsheet as a content calendar, and as such I'm only including one date (publish dates) - so the sheet won't work as a gantt (which is fine) HOWEVER, I would need to apply conditional formatting to calendar view (to create an automated colour-coordinated content calendar) but it seems I can't do…
-
lookup function
Hi Iam looking to replicate the below lookup function in excel to get the last number filled out in a column range =LOOKUP(2;1/(M11:M23<>"");M11:M23) However this does not work in smartsheet
-
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…
