-
Turn average working days to projected date using WORKDAY()
The basic ask is to calculate a projected due date based on historical data and duration that a certain task takes. So if x, y, and z parameters are checked, it will find the average amount of time (from a different sheet) that those parameters take and then calculate a suggested due date. I want to use WORKDAY(), but am…
-
assigning fields when setting up a JIRA to Smartsheets workflow
HI, I have an end date field in my smartsheets workbook. When I setup an workflow to import from JIRA I am unable to find the end date field in the drop down table as below does anyone know why this is?
-
Setting chart colors before all options have values.
Hi, I am trying to show a series of data statuses. Currently, all of the status are "Open" (work has not started). I have all of the options selected as data for the chart, but SmartSheet does not allow me to assign a color until the values are greater than "0". Is there any way I can preset these colors so that when the…
-
Searching a series of columns for blanks
Hey all. I am trying to have a column search a series of columns and return the data from the column that is not blank. I have started with the following: =IF(NOT(ISBLANK([Title:]1)), [Title:]1, [Peer to Peer Program Title]1) Which checks the Title column, and if not blank returns the data from Title: column. If the Title:…
-
Pulling data from one sheet to another
Hello: In Sheet 1, I have Column A that lists courses to be developed in the next term. There are several rows, but not every row contains a course. Row 1---BUS 123 Row 2---CUL 232 Row 3--- Row 4---DSH 343 Row 5---ENT 111 Row 6--- Row 7--- Row 8---HSM 399 In Sheet 2, I would like to include the list of courses from Sheet 1…
-
Conditional formatting based on location in hierachy
Please consider incorporating a functions level() and has_cildren() in the conditional formatting and reporting filters. level() would give "0" if top level and "1","2" ... depending on the number of indentations. has_children() retruns true or false. Combined this would allow: - making filtered reports only extracting…
-
need a function to set permission to one cell,or one column
need a function in smartsheet to set permission to one cell,or one column, it means, the viewers can view most of the datas in the sheet,but one or two cells,one or two columns,take the classified column within revenue for example, the datas inside of this classified column just can be viewed by owner and admins, the…
-
Formula that needs to reference multiple columns
Good evening, We are looking of how we would structure a formula to calculate the % of our production job each series is responsible for. * There are 6 series (sequences) in this job. 1 thru 6. In the "Series ID" column. There are 300 rows +/- that make up the 6 series * The 6 series make up 100% of the job as calculated…
-
Dashboard and Sheets - Making 0 appear instead of error or formula
Good evening When we are setting up dashbaords and we have not yet enetered data , how do we make that data show a "0" instead of "# Divide By Zero" , it just looks messy.... Thank you
-
Adding New Items During Update Request
I have a report page where I've been testing the "Update Request" feature through a custom form. It works well for updating existing information, but is there a way to also add new line items with that request? For example: If I am sending an "Update Request" for a user to review a list of existing fruits and vegetables…
