-
Help with a COUNTIFS Formula that contains OR and Divide to calculate a %
Hey Guys I wonder could i pick your brains to iron out the kinks in my formula I would like to calculate a % based upon the following references Sheet Reference {EPIC} Value "GBT-xxxx" Sheet reference {JIRA STATUS} Value "Pass" or "Fail/Issue" or "Gap" or "Pass - Now Fail" or "N/A (Not Applicable)" Divided by 234 which is…
-
Formula for updating window of time to different time zones...
I am creating a form to schedule meetings however, I need the times I have listed in Pacific Daylight Time (PDT) to be converted into Mountain Daylight Time (MDT) (PDT+1 hour), Central Daylight Time (CDT) (PDT +2 hours), Eastern Daylight Time (EDT) (PDT +3 hours), and Greenwich Mean Time (GMT) (PDT +7 hours). I am manually…
-
Automation Not Running as Scheduled, Nor Consistently, But Sometimes at Random?
I have 22 projects with identical tracking sheets and identical automation set up on those tracking sheets. The automation has been set to run every Friday for the last month. It just copies the current rows to another sheet, that other sheet becoming a "ledger". I have one column that says "todays date" so when I go to…
-
Challenges with combining SUMIFS and COUNTIFS
I am using the Sheet Summary to input formulas helping me to track the COUNT of installs that took place in a given month/year. But now I want to SUM how many assets were installed at that location using the same date criteria. My formulas below are allowing me to COUNT how many rows (AKA customer locations) fit my…
-
formula help
hello all, can I get help with this - I am trying to count the "√" in column DAY 2 but its in a children lines from parent line 03.2025 - that is a children's line for parent line 2025 I don't know what am I doing wrong =COUNTIF(CHILDREN([DAY 2]:[DAY 2] "√"))*8.5
-
Help Article updates - February 2025
Hello Community, We’ve published the following new collection of articles that highlight specific capabilities for builders: Basic Builder Learning Track: Intake to archive Basic Builder Learning Track: Project settings Basic Builder Learning Track: Reporting Basic Builder Learning Track: Visualizing process performance To…
-
Dashboard Charts - Color Change Issues
Hello, I have had issues with my dashboard charts changing colors when values drop to 0 and then come back above 0. It changes everything and I have to manually fix this issue. I found a solution on the Smartsheet community site that recommended adding +0.0001 to the end of the value. This solved my problem but created…
-
Hi! Can someone please help me with writing a formula for my summary field?
I need to count rows if “Target Start” is between the Friday before last Friday and last Friday, “Work Type” is "EMERGENCY”, “Work Order” does not contain “IMP”, “Status” is not one of “Cancelled” or “Closed - Out of Scope” I've tried: =COUNTIFS({Target Start}, >=TODAY() - WEEKDAY(TODAY(), 2) - 2,{Target Start}, <=TODAY()…
-
Help with a weekly updated formula
Hello! I'm still a beginner smartsheets user, and while I am decent with excel the live updates is still very new. I'm trying to create a formula that will pull information on a weekly basis, M-F, that updated for each week and didn't pull from the previous week at all. For example in this screenshot, I would like a…
-
COUNTIF formula between date range
I'm trying to do a countif formula between a specific range of years, while referencing from an alternate sheet. This is the sheet with all my data (of course, just a small example) And this is the range within which I'm trying to work. For 1976-2000, the formula I have is =COUNTIFS({Game Design Range 2}, >=1976), but…