-
Best way to calculate stats on a sheet tracking form submissions
I have a SmartSheet that logs "installation issues" as they are submitted via web form. The sheet tracks the "locations" id number, address, owner, manager, issue, issue type, and who is working on the issue. Its a tracker you could say. I want to be able to calculate how many of "issue type" A or B have been submitted via…
-
Any updates to "View permissions on individual columns & rows"
Hello, The original "View permissions on individual columns & rows" was posted in 2016. The end result appears to have been you could not set permissions for individual columns & rows on a sheet but the request was being noted as a possible enhancement. Has there been any movement on this? I currently have a "Main Sheet"…
-
RYGB
I am trying to develop a formula that will look at multiple columns to return a RYG status. If "Sign work?" is box is checked THEN Look at "Sign projected ship date" & "Sign actual ship date" compare to "Sign need date" Here's where I'm not sure on the logic sequence: If "Sign actual ship date" is null - Use projected to…
-
Activity Log - Is there a way to limit who sees it?
Is there a way to hide the activity log from users or limit the view? We make changes to Project Plans especially in the beginning where we don't want a client to see it. It could raise a lot of questions and concerns.
-
Cell to test if an ETA has passed without an order delivery
Hello, I'm trying to generate a report that shows any orders that have passed their ETA without delivery. In the sheet, I have figured out how to highlight the row with conditional formatting, but I'd like to extract the order essentials into a report that I can surface to three different managers via a portal/dashboard.…
-
Updating Info on the Projects Index Sheet
Hi all, Consider that I have an index sheet that lists all the projects (active or not), with the current task, it's description, timescale, owner of the task, and also the task that will come next. Parallel to that, I have individual sheets for each project that list all the information above, and also all the remaining…
-
Predicting a Date based on what type in as I complete a step
The first column are the dates I complete a task. The fourth column are how many days I have to complete the task. I'm trying to predict the completion date as I enter the dates in the first column. The expected completion date will move up or down depending whether or not I finish the task on time or a few days earlier.…
-
Alerts not going every time and to all addresses?
I have many (20) alerts setup on a support queue sheet. Some of those alerts need to go to multiple people. I've set the alert up correctly to send to up to three recipients. I am one of those recipients. I know the alert triggers because I received the email alert, but the other two did not. I've also seen where one of…
-
Sync cells content according to date in different sheets
Hi there, I'm new to Smart Sheets and I'm trying to achieve the following. I'll try to explain. I have manually created a calendar, in normal grid mode, which has a 3 month view side by side with blanck cells next to each day where i can manually add content. I have another sheet, in card mode, where I can manage basic…
-
Link View By & Levels Dropdowns
I am trying to setup a a card view with two main View By filters; (1) by assignee, and (2) by project type. When using (1) I would like the Level drop down to be All Levels, but for (2) I would like the Level drop down to be only Level 1. Is there a way to have this happen automatically, since it doesn't make sense for…