-
How to use COUNTIFS by Week?
Hi- I am trying to write a formula for how many locations have officially opened per week of this year. This is what I currently have and all it gives me is 0. =COUNTIFS({Official Opening Actual}, IFERROR(WEEKNUMBER(@cell), 0) = WEEKNUMBER(TODAY())) For the Official Opening Actual, I am referencing another sheet. I am not…
-
Formula's Broken
Team, Am new to Smartsheets and am trying to create metrics sheets that I can then create reports and dashboards from. The formula I am using, for example is: =COUNTIFS(Renewal Victories V2!Agent, "Name 1", Renewal Victories V2![Platform - BSG], "<>") I can't figure out why none of my formulas will work. I am trying to…
-
Reporting/dashboard on form entries
Our Referrals departments has recently started utilizing a smartsheet form to track key information on each referral that comes into our hospice. Each team member completes & submits the form when they get a referral. I have the sheet set to automatically date/time stamp each row as it comes in. The department heads are…
-
Count with multiple criterias (one or the other criteria)
Hi all, I am trying to count based on two criterias (if it's one or the other, they don't need to be both meet) Thank you.
-
lookup with multi select dropdown contact list
Hi All We are very new to smart sheet tool and we are currently in process of setting up our projects and creating a list in it. the problem we are facing is for example we have a project that is running in several countries as we speak and we want to look up the responsible persons email addresses for all those countries…
-
Automations and Cell Linking
Hello, I've read in a few past threads that automations will not work with Cell Linking. For example, I have a column that uses VLOOKUP to pull a Status from another sheet that is imported via Data Shuttle on a daily basis. I wanted to have the rows moved to my completed sheet anytime the Status changes to Closed. It would…
-
Update Status formula - late versus complete
Howdy, Question. I am using a status formula: =IF(Finish@row < TODAY(), "Late", IF([% Complete]@row = 0, "Not Started", IF([% Complete]@row = 1, "Complete", "In Progress"))) This formula populates the status based on the % complete and due date. It works well, with one exception. If the % complete is marked 100% after the…
-
IF with 2 sets of criteria -
Hey I'm trying to get a tickbox to show at checked if : The ticket ID matches from another sheet The tickbox is also checked in that same sheet =IF(AND({TicketID} = [Ticket ID]@row, {Completed} = true), true, false) I have also tried replacing true/ false with 1/0 Thanks!
-
Rolling up RYG status by workstream
Hello, I'm looking to write a formula that averages my health status, but by the workstream column. For example, in the screenshot below, I'm looking at the "Equipment and Technology" workstream. I am using a separate metrics sheet to write the formula, as there will be one roll up status for each of my workstreams…
-
Use Index Collect to Pull in Formula?
I'm creating a project plan that uses index collect to pull information from another sheet into my project plan. Everything works great but on a couple cells I'd like to pull in a formula. Is there a way to do this? In my other sheet I've inputted the formula which shows #UNPARSEABLE (because I don't have the references…
