-
How do I unshare individual sheets in a Workspace?
I need to share a workspace with some users with the exception of a few sheets that have confidential information. Is there a way to share everything except those sheets? There doesn't seem to be a way to do that without removing workspace access and then resharing every other sheet, report, dashboard, etc. manually. I'm…
-
COUNTIF(AND) FUNCTION
Hi again, I am trying to write the following formula and am not getting the answer I am looking for. My goal is to count the late items in a task sheet. This require two parameters to be met. the date is in the past the progress status is not "Complete" =COUNTIF(AND({Due Date Range}, <TODAY(), {Progress Range},…
-
Averageifs Question
Hello! I am wanting to do an averageifs statement, but it does not seem that is supported. Is there another way that I can calculate an average based off fitting two different criteria? Right now, I have this equation, which works for when just hitting the one criteria: =ROUND(AVERAGEIF({System Request}, [Ticket Type 2]1,…
-
Viewing Submitted Forms
Good morning, I'm creating a form that I'd like to be able to save the responses as a PDF document. As far as I can tell, the only way to see submitted forms is through the sheet itself - not in any "document" format that could be easily saved to a DMS. Is there a method to show submitted form data in a way that would…
-
What happens to my automation if I run out of rows?
Hey there! I am working with a large archival destination sheet: We haven't hit 20k rows YET, but it'll probably be coming this year. The automation moves Completed rows from an active tracking sheet to the archive sheet- we keep that for a full accounting of these completed processes. But.... what happens when…
-
Dashboard with Filters - Best Practice
Hi all, I am pretty new to Smartsheet and will need your help to build a dashboard. What is the best practice to create one? GRID I have multiple salespeople in my team, each of them have their own grid. The grid looks something like this: ID | Date | Stage | Comments I am creating forms for them to fill up on a daily…
-
Trouble with VLOOKUP syntax error in some, but not all, column formula selections
Hello, I am having some inconsistencies with turning VLOOKUP function into a column formula within the same sheet, I am using VLOOKUP in three different columns. One of the columns allows me to turn it into a "column formula", but the other two give me a syntax error (SEE last and final photo for error message). See screen…
-
Count and Concatenate Text
Count the total number of checked boxes in the children rows of [Completed] and compare that number with the total number of checkboxes using concatenated text. Your answer should look like this: "Total Completed: _ of _"
-
Pulling from Multi-Select to populate under appropriate line in another sheet
Hello, I am using the attached formula to try and ensure that I can expand the formula (currently has a 1:1 from a Project plan with RACI into a RACI Matrix with tasks associated to users) so that rather than creating a duplicate row for every person responsible (from a group) I wanted to change it to a multi select and…
-
Sort data in multiple columns in order by date
Hello! I have an overview sheet where each job is it's own line and each column is a specific milestone I'd like to track that is linked back to the source timeline. I created a report with just the job names, job number, and then review 1, review2, review 3. Each review column has a date assigned to it (linked from the…
