-
COUNIFS formula when multiple contacts
I have a sheet with columns such as "Status of Request"(Dropdown list: New, In Design, Completed) and "Assigned Designer"(My assigned designer column allows multiple contacts). I want to count how many projects under the status "In Design" for Designer "Luis" do I have so I have the formula =COUNTIFS([Assigned…
-
SUMIFS Cross Sheet Issue
Hello Everyone! I am needing help with the SUMIFS formula for cross sheet reference but when I enter multiple criteria, it returns a value of 0. What I am trying to accomplish is a sum for Sheet-2 based on multiple criteria from Sheet-1: Criteria from Sheet-1 * Job ID* 216116 * Cost Code ID* 7 * 15 * 16 Sum Range: Act.…
-
Dependency Settings specific to each day
Is there a way to allocate specific hours on individual days e.g. Mon 7 hours , Tuesday 8 hours etc
-
Widget when Pulling Reports
Hello, I would like to have multiple reports(because of the different people assigned to different projects) on my Dashboard but I only need certain columns from each report. How can I make this possible. Thanks!
-
Creating a Chart from Non-Numerical Data for a Dashboard
I would like to have a pie chart on my dashboard that displays percentage of types of activity from a column in a sheet. More specifically, I have a column in an IT tracking sheet that has a dropdown menu. I would like to be able to display on a dashboard the percentage of each activity in the sheet. (e.g., a pie chart…
-
Sharing Multiple Sheets with a User at Once
Is it possible to share multpile sheets with a user at once? I have several sheets that I would like to make accessible to one of our users, and the only way I know of to do this currently is to go into each sheet and share one at a time. Is there a faster way to do this? Also, can I quickly view who is currently shared on…
-
Recurring task with task results stored per row
Good morning all I have created a grid for 'preventative maintenance' program - whereby the grid shows the task, owned by, frequency (daily/weekly/monthly etc), date last completed (user enters this each time they complete the task) and date next due is calculated (from the date last completed). But - my gap is that i also…
-
SMART Sheets for branch audits
Can anyone support? I want to use smart sheets for auditing several branches in our company. Has anyone done this and can share an example?
-
Workflow to create an automatic update request
Hi everyone, I have a sheet with all the projects from my site supervisors. I'm sending them a weekly update request to find out the hours worked, incidents, etc to be filled on a form. I created a workflow but it did not work properly. Not sure what I'm doing wrong. Any help would be appreciated. P.S. See attached picture…
-
How to stop due date reminders once task has been completed
HI- We use Smartsheet for tasks that need to be completed by several people. We currenlty have reminders set up for due dates (both 5 days before due date and past due date). Is there a way to NOT send the reminder if the task has been completed/the 'Date Completed' field has a date in it?
