-
Is there a better way???
=IF($[Year Select]$2 = "2023", [2023]@row, "" + IF($[Year Select]$2 = "2022", [2022]@row, "")) I am having an issue where I can select 2023 just fine, but when I select 2022 all of my reference dates change to a "Text date" and the formula in the data 1 & 2 columns do not recognize it. Is there an easy way to fix this? Or,…
-
Looking to reference a sheet name on a different sheet
I have a sheet that uses a nested formula to scan 3 different sheets to pull in specific data related to a Sales Order number. Is there any way to craft a formula that will produce the name of the sheet where the information was pulled from? -Using a report will not work because the function of the file is to pull in…
-
Find unique value in Children
I am looking to determine if a value in a cell of a child is unique among the other children. Order Number | Items | Cost | Overall Unique | Order Unique | Total + 100 | | | 101 | Oranges | $1.00 | Yes | Yes | $1.00 102 | Apples | $2.00 | Yes | Yes | $2.00 103 | Bananas | $3.00 | Yes | Yes | $3.00 + 200 | | 204 | Pears |…
-
How to fix #UNPARSEABLE for my nested IF formula
Here is my nested IF formula and I don't understand where the issue lies. I've created a new column called [Initiative Expense] for my formula. My [Initiative Type] column has multiple values for types of expenses and credits, but if the value is one of five expenses (listed in parenthesis in the formula), then I want the…
-
Count children but only some of them
How should this formula look if I want to only count children that are 'Open'? ="Project stage name - " + COUNT(CHILDREN()) I am using on the parent row in a project risk register so I can collapse stages not reached to focus on the risks for the current stage. However, some of the risks in the current stage are now…
-
SUMIFS with 9 criteria
I am trying to sum specific values based on a dropdown list in one column and display that sum in another column. I have an "Amount" column , a "Total Final OEP 0708 Cost Center Spent" column , and a "Cost Center" dropdown column. I want to sum CHILD rows in column "Amount" based on the drop down option that is selected.…
-
Vacation Days Formula - calculating half days
Hi, I am trying to incorporate 0.5 days of annual leave into my vacation tracker. I have the forumla =NETWORKDAYS([Start Date]@row, [End Date]@row, {Bank Holiday Lookp}) to calculate overall number of days out (minus public holidays). From this total I then want to include any 0.5 days from this when 'half day requested'…
-
webhook suddenly stopped working.
I created a Smartsheet webhook last month, and it was working fine. However, from yesterday it stopped working. I faced the same problem before, so I created a new webhook, but now, even the second webhook stopped working. Can you help me understand the reason for this issue?..
-
Change of Symbol Value Colors
Hello- Is there a way to change the colors in these selections? e.g., I want to have "Orange" instead of "Yellow" and "Dark Green" instead of "Blue." =IF(Outcome@row = "Zero", "Red", IF(Outcome@row = "Check Minus", "Yellow", IF(Outcome@row = "Check", "Green", IF(Outcome@row = "Check Plus", "Blue"))))
-
Merged: Favorites List Sort/Display Order
This discussion has been merged.
