-
How to add new criteria to my current COUNTIFS formula?
Hi all! Not sure how to add the criteria do not add to count if cell = "Topic" to my current COUNTIFS formula. Current foluma is: =COUNTIFS(CHILDREN(Plan:Plan), "Fundamentals", CHILDREN(Role:Role), HAS(@cell, "IBX Customer Ops")) I need to add 'AND if the the "Deliverable" cell does not equal "Topic" '. Thanks in advance :)
-
Summary Sheet formula to count status by assigned person
Hi All, This should be a basic formula but I cannot seem to make this work for me and I am hoping that someone in the community can help me pinpoint where I am going wrong? I entered this in the sheet summary field - =COUNTIFS({Range - Standard Author}; StandardAuthor@row; {Range - Status}; "In Progress") noting the…
-
Start Date and End Date Form Entry Restrictions?
Good Morning, I know this is purely for cosmetic purposes in terms of putting the correct date in start and end. However, I was wondering if there was a solution to this problem using logic tab in the form section. My Users keep currently getting confused and putting there "End date" as the "Start Date" and the Start Date…
-
Date/Time Stamp Option
While trying to figure something else out, I stumbled across a new option for having specific actions date/time stamped using the stem generated Modified (date) type column and the new Copy Row automation. . DISCLAIMER: This does not scale very well as is. If you have a lot of rows you are wanting to track a lot of changes…
-
AUTOMATE PROGRESS BAR BASED ON MULTIPLE CONDITIONS
Hello, I am trying to automate my progress bar, basing it's progress on multiple conditions. I have 10 columns I would like the progress bar to consider. Example below of how i would like it to work: If Cost 1 AND Hours 1 IS NOT Empty then progress = 25% If Parts AND Survey AND time IS NOT Empty then progress = 50% If…
-
Maximum cross-sheet references
Once you reach this figure of maximum cross sheet references how can you get around this. I want to configure calculations to 2030. Got to June 2025 before I got stuck. Regards Steve
-
Rolling Fiscal/Quarterly Counts?
How would I go about populating the number of something happening within a certain Quarter or Fiscal Year? In this instance, I want to count the number of Cross-Dock orders that happened in the last quarter, but then also for the entire fiscal year. Another example of how I'm trying to use this is that I'm trying to gather…
-
Formula Error
Hi I have the following formula that should look at the number of projects in a programme RAG statuses and return back a Red if there is 1 or more project with a Red RAG, return a yellow if there is 1 or more projects with a yellow RAG, otherwise return "Green". =IF(COUNTIFS({Project to Programme Summary | Project Status},…
-
Delete or Modify Cross Sheet References in Smartsheet Gov
Smartsheet Gov doesn't offer the same handy-dandy Sheet Reference Manager as the commercial version (don't know why) that allows you to delete, etc. Is there a good, easy way to do this in Smartsheet Gov?
-
Someone please help me get the "=COUNT(DISTINCT(COLLECT(" formula correctly?!
HI there team, Trying sum up the Summary screenshot by unique Shops/Customer registered. Data is coming from the different file which is a registration file, and for some reason I cannot get the formula to work. Attaching a sample. thank you!
