-
Count IFs or Sum IFS Formula
Hello all!! So currently trying to get a sheet summary formula to show the number of Dealer ID's that are not enrolled. Pretty much just need the number of Dealer ID's shown on the SS when the Enrolled Checkbox Column is not checked. There should be 162 Dealer ID's that are not checked but the formula I am using is…
-
Show parent OR task at same level as parent in report
My past due report was showing the naked tasks without context, so I wanted to add the parent. I added a helper column with '=(PARENT(Tasks@row)) and grouped the report by that column. That works for some of the items, however here's the issue, some level 3 items have sub-tasks and others don't, so some tasks are at level…
-
Return a value if an item matches
Hello - new to formulas & struggling to get one to work. I have two sheets: One with the values in column format (Payer CSS Responses by Initiative) - this was done so specific drop down options can be chosen; and one that contains those same columns but in row format so that it easy to view (Payer CSS Template). What I'm…
-
My formula doesn't work when I choose the first of the month as Effective Date
this is my formula: =IFERROR(DATE(YEAR([Effective Date]@row) + ROUNDDOWN((MONTH([Effective Date]@row) + ([Contract Term (Months)]@row)) / 12, 0) + IF(IF(MOD(MONTH([Effective Date]@row) + ([Contract Term (Months)]@row), 12) = 0, 12, MOD(MONTH([Effective Date]@row - 1) + ([Contract Term (Months)]@row), 12)) = 12, -1),…
-
Help with formula
I am setting up as simple tracking of an annual communications plan and have a Platform of Engagement column with about 12 drop down platforms to select from. I want a formula to track the amount of engagement on each platform selected within this column. The following formula works counting for one platform of engagement,…
-
Smartsheet Formula for Multiselect cell based on time
Hi, I have created a form for our clinical therapists to enter type of service or referral provided for particular clients each week. I want an automation that takes this data and lists services provided to a particular client on another sheet if it was completed in the past week. The formula I've been working with is:…
-
Formula for Hours Scheduled by Month
We're trying to determine how many hours we have scheduled in a month for a particular project based on the start and end date of the project. I can't quite figure out how to set the MAX/MIN without the EOM function. Can someone please help?
-
Working with data betwen two sheets and mutliple columns
Good Morning All, I am having with an issue matchhing data between two sheets based on certain criteria. 1st sheet is a list of form responses. I have a name of requestor column. I need to complete two objectives based on this requestor. See if their name exists in one of two columns on another sheet. 2 if their name…
-
Formula for counting publications in a calendar year
Hi, Here is a background on what my ask is: We track publications on Smartsheets and the publication activity column has the following drop-down options: Journal Article Meeting/ Conference Abstract/ Poster Book chapter Non-authorship contributions to publications (acknowledgement) Non-scientific presentation (podium/…
-
COUNTIFs for multiselect drop downs
Hello, I have a set of form responses where 350 colleagues have given their job level, and provided their 5 personal goals (in separate columns), and which of our organisational targets their goal aligns to. They have selected the alignment to our organisational targets from a multiselect dropdown, and some people's goals…