-
Order of Operations -- PEMDAS syntax
Hello, I am currently designing a Quiz, but I am having an issue with my syntax and I was hoping someone could explain what I'm doing wrong. Basically, I have a test that is worth 208 total points. Let's say that there are 84 questions and each question is worth 1, 2, 4, or 6 points. Here is where the twist comes in.…
-
Convert date format to "YYYY.MM.DD" in formula that combines date and text
Is there a way to do something like the excel formula =TEXT(TODAY(),"YYYY.MM.DD") in SmartSheet to allow a specific date format to appear in the output of a formula, regardless of the user's regional settings? All of our date columns have been set to the YYYY.MM.DD format, but we have formula columns that combine dates…
-
Formula Help
I need a formula that pulls the data from the column if that cell is not empty. (Ex; If 1 is empty but 2 is filled, pull data from field 2). As-Built Production Yield Final Production Yield 90% Production Yield 60% Production Yield 30% Production Yield Total Production Yield Target My current formula is below but it does…
-
Is there a widget that can show active requests on dashboard?
Hello, Looking for a way to display all current requests / notifications, and due date on a widget on an individuals dashboard. My sales team is used to Asana tasks and sub tasks, trying to make them more comfortable with their new dashboard.
-
Formula help: Cross-sheet formula count checkboxes for children only
I'm looking for help with a cross-sheet formula that counts selected checkboxes in a column but only counts child rows, and only where the user name is not blank. I have a checkbox column for Parent and also a helper column identifying parent numerically (0/1). I haven't been able to figure out a formula that works. Any…
-
IF formula returns unexpected TRUE result for text cells that start with the < or > character
I have text column in one of my sheets named EN Display Name. That column cannot contain duplicate values, so I added the formula below to a helper column in the sheet to make it more obvious when multiple rows had the same value in the EN Display Name column. =IF(COUNTIF([EN Display Name]:[EN Display Name], [EN Display…
-
Help to avoid hundreds of conditional formatting
Hi all, I have a sheet with columns that list a particular service. My rows are site names and we're tracking the level of adoption for each service with the below list: FI (H) FI (NR-H) FI (NI) C-FI P NI V N/A I want to have each one colour coded like you would with conditional formatting but I have 28 columns and so if I…
-
Why do I get #incorrect argument set?
Is there a limit to how many criteria I can use in a sumifs function? I can't figure out where I've gone wrong in my formula. I have double checked the references at least 10 times... Please help! =SUMIFS({Import sheet Range 1}; {Import sheet Range 2}; $Fas@row; {Import sheet Range 3}; $Roll@row; {Import sheet Range 5};…
-
Formula Variance Help
Good Afternoon. I am looking to set a Baseline Start and End date; however, I have several Phases that I would like to include to capture the change in phases. (i.e., prospecting how many days we have prospected a client and when the transition to implementation goes live. Etc. Is there a way to capture the movement in…
-
COUNTIF Formula with 2 Criteria - Status & Checkbox
Hi, I am trying to create a summary sheet from a detailed project schedule and would to create a COUNTIF formula that adds to the countif sum if the row status column is "complete" and the internal milestone column is checked; however, I am receiving an #UNPARSEABLE error and not sure what the issue is. Here is my formula:…