-
Collaborator Name not Recognised When Trying to Apply a Filter in Activity Log
Hi, when looking at the activity log for one of my sheets I can see the names of the collaborators the sheet has been shared to. However, when I try to filter on one of the collaborators I'm met with the error message "Unknown User Entered". It doesn't matter if I use their christian name, christian name & surname, or full…
-
If(And(Or
I'm trying to create a formula that includes If, And, and Or in it and I'm having trouble figuring out the correct way to write it. Written out what I need is: If "restrictions in place through" is greater than 3/28/2020 OR equals UFN AND "max # of people.." is greater than 0 make "local ordinance status" yellow and If…
-
Create a work report
I have a Gantt of a project which has weekly minutes compiled of site meetings and others. How do I create a specific report that goes to the project manager and asks him to load specific copy onto smartsheet?
-
HELP with a large sheet and table layout/conditional formatting
I spent 15 hours trying to organize my data in an efficient way and just can't come up with a good solution. Smartsheet is great but SO limiting if you are used to Excel. I have 200+ sites that each has 31 activities. Each activity has 3 dates - planned date, reforecasted date and actual end date. I need a report that…
-
Help With Adding More Conditions in Current IF Formula
Hi everyone, I am currently struggling to add more conditions to my current formula. The formula is: =IF('Department 1'[Approval Response]="Pending" && 'Department 1'[Past Due/Scheduled]="Past Due",1,0) I want to add two more conditions to the approval response: "In Process" and "On Hold", while keeping the second half of…
-
Date formula returning "#INVALID DATA TYPE"
Hi guys, I can't figure out what's happening here, hoping someone can point me in the right direction Importing a table with a "Date" column set as primary column, Date format is YYYY-MM-DD Trying to convert the value into a format I can use by splitting the date string into it's seperate components using MID function, and…
-
Incorrect counting of blank rows
="Completed " + COUNTIF([Completed Tasks]:[Completed Tasks], 1) + " of " + COUNT([Completed Tasks]:[Completed Tasks], IF([Task Name]:[Task Name], "")) I have a checkbox column that will read in the summary bar (row 1) when working "Completed 6 of 33" However, it is counting blank rows and should read "Completed 6 of 25"…
-
Verify All Sites Submitted Response Today
Hi, I'm trying to track if a site (or Name) created a new daily entry using a Smartsheet form. I added this formula to the Updated Today column to return a "Yes" answer if the site (or Name) created a new daily entry. This seems to be working as intended. Is there a better way to design this formula? =IF(Created@row =…
-
Counting physical inventory while removing duplication...
I'm trying to count the number of unique pieces of equipment that are on my worksite. Each unit has a specific Unit Number listed in a sheet. Units that are On-Site are indicated by a green dot in another column. The tricky part for me is, some of these Unit Numbers have multiple work orders which are listed on another…
-
How to ensure data privacy?
Hi I want some of my users to be able to submit data using forms. But in order to be able to fill out a form, the users must have shared access to the sheet that contains the input form in question. With sheet sharing enabled, the users can easily see other users' data as well, which I want to keep confidential! Is there…
