-
What is the formula that I will need to track how many completed projects an employee has worked on
Here it the formula I was trying but I kept getting an #INVALID REF. =COUNTIFS({DCIM Projects 2020-2021 Range 1}, ="Complete", AND({DCIM Projects 2020-2021 Range 2,="Susan ****"})) (Replaced employees last name with * for privacy) We have a few projects that take multiple employees and some that it is individual. I am…
-
Forms - Email Confirmation Help
I setup a workflow automation to send an email confirmation to individuals who registered for one of our events. The email confirmation reflecsts my name "Brandy Allen" as the sender. Is there a way to remove my name as a sender, or create another name in its place?
-
VLOOKUP in a separate sheet not working
Hi, I have created a sheet where I have a series of checkboxes on each row where each checkbox represents a particular service that we provide. I then have a column function that is meant to add up all the services selected by checking the checkboxes. The function works in general, but I am experiencing a really weird…
-
CONTAINS not returning results
I'm having an ongoing problem with using CONTAINS to count the occurrence of a value in a multi-select column. Here is my sample data: Here is the formula: =IF(CONTAINS("East", [Column2]:[Column2]), "Yes", "No") As you can see, the first and second-to-last row should return "Yes" and the rest should return No, but they are…
-
Creating a mastersheet
Anyone can help me to create a mastersheet to pull in info from several sheets? eg I need a total on the mastersheet to be reflecting a tally from the individual sheets. So column total in sheet 1 and sheet 2 = total in sheet 3 (mastersheet)
-
Checkbox if 2 Criteria Met from Different Sheet
What am I missing: I have a date and time from a master sheet, if both match want the checkbox in a second sheet I can get the the formula to work if separate but when I tray and combine they do not work Date Check Formula: check box works =IFERROR(IF(INDEX({Test Range 2}, MATCH(Date@row, {Test Range 2}, 0)) <> "", 1, 0),…
-
Autofill Date with Dropdown Selection
Hey everyone. I am trying to figure out how to make my sheet autofill today's date when we complete a project. We have a status column and when that column is marked "Completed" I want the Completion Date to autofill to today. I tried this: =IF(Status@row = "Completed", TODAY()) The problem is that it changes the completed…
-
How to get a tally of rows fitting relative date criteria (start date within last 30 days etc)?
Hi team, I have a Smartsheet used to track defects reported for the product I manage, and I need to report on 3 metrics. 2 of these are based on relative dates (sheet includes Start Date and Date Closed columns) and my team hasn't been able to get the formulas parsing properly. I'd appreciate any help or advice! Total…
-
Automated Reminders Based on Approaching Due Date
Hello Community, I am attempting to produce an "if/then" statement within a column of my project management smartsheet in order to create an email automation to remind the assigned user to address the aging task. Using the formula, I should be able to create conditional formatting or email automation workflows that address…
-
Project Plan Template Formula Issue
I have a question on a formula used in a project plan template currently being used. Many times, the % complete (expected) is greater than 100%. The formula currently being used is Expected Effort Complete/Cumulative Effort. The Cumulative Effort is the duration of the task, in days, and the expected effort complete…