-
No idea where to start?!?!?
Hi all! New to smartsheet and struggling with formulas. Here is the sheet I am currently working with (Sheet A) I want the column labeled DC AVG to populate the total AVG for all Doc Control lines, from the Date of Inspection and any dates prior. (I manually populated the existing data in DC AVG) Similarly for LP AVG, I…
-
Prohibit a cell from being marked as complete
Hi everyone, Does anyone know how you can keep someone from completing a line item? I have a sheet where I ask for a resolution to an issue and some users are marking the item as complete without providing the details of the resolution. I would like to block them from the cell until data is entered into the resolution…
-
How can I best organize lots of different 'tags' to sort through
I'm moving a sheet over from Google Sheets. Right now we have a column for 'Specialties' for different medical providers and it contains keywords we need to be able to search by. I need to be able to sort through this data quickly. I don't necessarily want it as a drop down because there are over 100 different…
-
Formula when a column has a checkbox
I cannot seem to find this answer: When a column has a checkbox, another column must have data in it or it will turn red Example. If someone is needed on site (it is checked) then a person(s) name must be in the box. They cannot leave it blank or it will be red. On Site Person <star> Contact List or cell is RED
-
Open files in a new window
A recent update in Smartsheet changed the way we view files. Previously, when you clicked on a file it opened automatically in a new tab and this meant you could have several files open at once and the ability to move between them. The update removed this function and now the file opens in a preview window with little…
-
Merged: "Log in as" Feature for System Admins
This discussion has been merged.
-
Aligning week number to financial year
Hiya, Asking this question again as I have still seen no solution here. In a gantt chart is it possible to align the week number with a financial year? In our business our financial year starts the first week of July - This however comes up as week 27, not week 1. Cheers
-
How to set-up Data Shuttle to show changes from the last time a workflow was run.
Hi! I'm trying to figure out how to set-up Data Shuttle to show changes from the last time a workflow was run. For example, I have a sheet with the following columns. "Job Title", "Job Code", "Posting Number" (Posting Number is the unique identifier) and "All Submitted Applications". "All Submitted Applications" is the…
-
Missing Jira field in SmartSheet Workflow
Hi team, I am unable to add some fields though those fields are available within Create and Edit Issue screens. Those missing fields as in the red box of a screenshot. Can you help to look into this issue, please? Thank you!
-
Count Rows Where A Value in Multiple Columns is blank
Is it possible to count how many lines meet certain criteria AND have a blank value in Column 1 OR Column 2 OR Column 3? For example I have a Smartsheet with a questionnaire and am currently trying to calculate metrics from the answers in said questionnaire. One of my metrics is "Level 1 Completion" (which is equal to "Q1…
