-
Keyboard Shortcuts
Is there a published list of supported keyboard shortcuts? eg: insert rows
-
countif column values based on a monthly value
Hi, I am creating a table of count of values in a column based on what month is reported in another. the table I want is attached. The formula I am using is as below. Can anyone advise what need to change in the planned formula =SUMIF{V2.0 Eirabot - Gantt Range 1}},"12", {V2.0 Eirabot - Gantt Range 1} I also want to have…
-
Is there a limit to the number of users you can share a sheet to?
Is there a limit to the number of users you can share a sheet to? My sheet seems to not let me share any additional users beyond the ~175 or so people I have now.
-
GMAIL and Smartsheet Integration
Good afternoon Is there a reason why we are not able to fill out some of our columns on the Samrthseet Side bar ? It says "Please edit the following columns in Smartsheet" which requires an added step....... Thank you
-
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…