-
COUNTIFS
Can anyone help me figure this out. I'm trying to add a COUNTIFS to my sheet and I'm getting an Unparseable error. =COUNTIFS({Sales Ops Support Ticket Tracking with Form}, [Group Name/Portfolio]:[Group Name/Portfolio], "Gift & Home", [Salesforce Item]:[Salesforce Item], Account Owner Mass Update)
-
Formula for running six-month total points for many employees
I am tasked with designing a sheet to track points that employees (~250) accrue daily (Sunday-Saturday). Point categories are 0.25, 0.50, 0.75, 1.00, and 2.00. The running points total needs to be over six months. I'm not great at formulas and from what I've seen in other Community posts about running six-month totals, the…
-
Check a Box based on Content in Multi-select Drop Down Column
I need a formula to "check a box" (Column B), if Column A (a multi-select drop down column, has 2 or more choices "picked". Most entries have only 1 choice (from the drop down); very few will have 2 more more "picked". Possible?
-
Nested IF Formula
Hi All, I'm trying to create a shift overview for an upcoming project, and would like to be able to enter a Start Time and End Time into 2x cells, and for the formula to fill in "1" into the corresponding cells to create a calendar view. Example below (just 1s filled in until I know what the formula is!!). I've tried…
-
Help with Parent / Child row auto numbering
Hello! I have a sheet that is being used to track decisions. We have a parent row (blue) and then child rows (white) for each group that needs to make a decision. We want the parent row Decision IDs to be sequential numbers "EHR###". The problem I'm running into is that each child row gets an AutoNum as well so as new…
-
How do I make a column formula that automatically checks the box if another column contains 1.
I am trying to make a checkbox column automatically check its box if the column1 contains 1. It may be equal to one but in some cases, it could be 1 high or 1 low. How can I check to see if the cell in column 1 of the same row contains 1. I have tried =CONTAINS(1, column1@row), but the boxes aren't checking.
-
Sumifs?
Hi, From another smartsheet I am trying to pull the total % of time spent by individual project managers on various projects that are in progress. I thought it would be a sumifs formula but it's giving me an answer of "0" instead of the percentage. Below, I have it first pulling the % column, then the Project Manager…
-
Recurring Forms
Hello Smartsheet community, I am trying to find a way to make the Smartsheet forms recurring. For reference, after a user has finished submitting the information for a project, I was Smartsheet to ask if there is another project form he/she needs to fill out. If the user says yes, then Smartsheet would automatically go…
-
Filter and Count Formula
Hi! I am having a little trouble with a data field I am trying to create. (See below) I have figured out the formulas to calculate the first line (Master) What I need help with is a CountIFS formula for the others. These are on a master sheet and there is a column for workstream. I need to pull out only those Workstreams…
-
Weekday Function that displays last 7 days
Hello, I currently have a date column with =Today() that tracks the current last 7 days plus the current day, this is paired to data that occurred on the corresponding day in order to display metrics on a dashboard. As you can see there are zeros on the 25th and 26th as it was a weekend. I am trying to utilize the =Weekday…