-
Marking a task complete
If I have a task that is complete, how do I mark it complete where it moves it to the bottom of the sheet?
-
Use Smartsheet row data to populate a Template
I am looking for a way to automate a process to take data from a single row in Smartsheet and populate a template. Working in the construction industry, processes are slow to change and we still need to PDF documents for communication with our customers (RFI's, Change Orders, etc). I have setup the forms and procedures for…
-
Sending data to another sheet leaves formulars behind. SMART SHEEET I HAVE AN IDEA !
Back in Feb 2017 I spoke about (When sending a row to another sheet it leaves the formulas behind). It was explained to me that it dose this to avoid errors etc. The problem I having is that the sheet I'm building is so interactive meaning: (I send on the row when job is sold to accountant, he then fills in his data, send…
-
IF Function
I am trying to create an IF Function for Various Statuses (Not Started, Hold, Complete) - When selected, Drop Down changes to Gray ball for Not Started, Yellow ball for Hold, Red ball for complete
-
need to populate the quarter based on the date
Hi, I've 3 columns - quarter, quarter beginning, quarter ending and populated these columns as follows: Q4FY17, 30/4/17, 7/29/17 Q1FY18, 7/30/17, 10/28/17 Q2FY18, 10/29/17, 1/27/18 ... Now, in another sheet, I've a date column. I want to populated the quarter column in this sheet based on the other sheet - depending on the…
-
Remove print range lines from Gant view
I have a sheet which uses a gant view. After I had exported it, I now see print range lines running vertically on the sheet. Is there any way to remove these? I have found that the export functions don't meet my needs and I would rather take a screen shot of the gant, but the lines don't look good. Thank you very much
-
Sum of each Dropdown Option Selected Formula Help
Any Suggestions on the simplest way to formulate this? * Dropdown Column - "Part Status" * Dropdown Options - "Delayed" "Not Started" "In Progress" "Warehouse" "Shipped" I want to show a total sheet sum for EACH Dropdown Option shown. Part Status is only selected on the Parent Rows. Rows 4-287 with 30 Parent Rows. Thanks…
-
Tempo Account Field Not Updating in Smartsheet
We are working with a JIRA instance that is connected to Smartsheet and writes data both ways. The JIRA instance utilizes the Tempo Timesheets add-on. One of the fields in a Smartsheet contains a column that is mapped to the Tempo Account field which is a locked, single select custom field in JIRA created from Tempo. This…
-
MS Teams & Smartsheet
Hi all, I've noticed that when using the MS Teams desktop app I'm asked to log into smartsheet each time I want to view the tab, I click on log in and nothing happens. This only occurs with the desktop app, the browser MS Teams app works fine. Anyone else had this issue (screen grab uploaded)
-
Workspace sorting/hierarchy
I have a bunch of workspaces (each with neat organization setup inside them), but I don't see a way to sort, group, or create a hierarchy to the workspaces. Since I use Smartsheet both with my own company and with my clients, it would be great to have a way to "group" the workspaces so I can have "internal" and "external"…