-
Preventing Modified by and Modified when rows have formulas
Hello! All my sheets have automation (formulas). I am having difficulties keeping track of who has modified records. We do not have access to sheet history because we are on the Team Plan only. This is a huge problem because we have issues with managers not updating project status on a timely basis. I have no recourse.ā¦
-
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)