-
Formula Assistance
If in a sheet our project settings call out workdays and holidays. do we need to add workday or holiday in our formulas still to take those days out?
-
Formula Help
I have been trying to work on a formula within smartsheet and only part of the formula is working and I have been using AI through smartsheet. I need help with tha last 2 parts of this formula to get the date value to populate in the cell. The N/A portion works. Formula Description is used in AI is this =IF the [Kit Type]…
-
x-sheet formula help
I am attempting to write a cross sheet formula on sheet (call it sheet a) that returns the value of a column on reference sheet b, based on finding a string of text found in anther column on sheet b that matches a Project ID on sheet a. Here was attempt 1 that didn't work =INDEX(PERFORMANCE AMOUNT), MATCH([PROJECT ID]@row,…
-
Problem saving smartsheet spreadsheet
When I try to save any changes to the spreadsheet, it loads for a long time and then gives me the error: formName: ajax formAction: fa_gridSave serverStatus: false serverStatusText: CriticalException errorCode: 48
-
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
-
Need Help: Action required for continued Smartsheet and Outlook integration
I do not have a sys admin, its just me. so how do I fix this since I depend heavily on the plugin in my daily workflow? The Microsoft site only gives a command to check or change but I am getting this. This is super complicated I have to do a lot of things to PS and I keep on running into having to do something more. It…