-
If there is no info in the second date column leave the formula cell empty or say "incomplete"
I can either get the calculation to work or I can get it to say Incomplete when the second date is empty. How do I get it to do both?
-
Dynamic column reference
I have a smartsheet setup to act as a daily tracker based on working day with statuses of the activity getting updated using a formula. The formula I am using currently is: IF(AND((ISBLANK([WD13]@row)), NOT(OR(SubStatus@row = "Completed", SubStatus@row = "Not scheduled to start yet"))), "Daily update pending",…
-
SUMIFS with 3 criteria
Why is this function not working? =SUMIFS({Mai'23 Datenbank}; {Gruppe Datenbank}; Gruppe@row; {Ressourcentyp Datenbank}; [Ressourcen Typ \[FTE\]]@row); {Priorität Datenbank}; Priorität With only 2 criteria it works fine but when I add the third criteria smarthsheet will show #UNPEARSEAPLE I want to SUM FTE (Mai`23…
-
Complicated Index Match Formula
Hopefully someone can help me out with the below scenario: I need to pull Company Name from another sheet that matches the Name (ie AAA). Then I need to pull the ranking which is a different column in the same sheet that matches both Name and Company Name.
-
CountIfs / OR Function for Sheet Summary Formula
Hello, I am trying to create a sheet summary formula that counts status columns if it meets the following criteria. However, I using this OR function doesn't work: =COUNTIFS(Status:Status, "1. Qualification", OR(Status:Status, "2. Proposal / Tender", OR(Status:Status, "3. Waiting for Deposit"))) Is there way to achieve…
-
How to check a box if exact text is found within a string of text
Hello, I am trying to place a check in a box when some exact text is found within a string of words. I am looking to place a check when "TAC" is found in a string of words. Here's the formula I am using, but its not working. No error message, but is not selecting the checkbox appropriately. =IF(HAS([Column Name1]@row,…
-
Issues with Auto-Update Dates
I have a project schedule with start and end dates listed for each phase of the project. (Phase 1: Start Date - 2/1/2023, End Date - 3/1/2023). I am experiencing issues with the year automatically updating in the date columns when a new year begins. I want the year in the date columns to automatically update to the current…
-
Need help with a SUMIFS function
Hi All I need a bit of help with a SUMIFS formula. What im trying to do is: Source sheet is called "KPI Master data". On a new sheet i am trying to input a formula that will subtract column 4 against column 3 if the date was yesterday in column 1 So far i can get it to work just by looking at a cell =SUMIFS({KPI Master…
-
Count of entries in the last 24 hours
Hello, I've got a sheet to record our queries as they come in and I'm looking for a formula to count the number of entries received in the last 24 hours as a running total I can monitor. At the minute I have set it up to count the queries received yesterday as per formula below but I'd be glad of some help how I can amend…
-
Find and Replace to edit references
Hi! I am trying to edit the three cross-sheet references in all the columns from the master sheet of 2018 to master sheet of 2019. Since I need to repeat it for almost 1200 cells. Is there a way to bulk edit like Find and Replace or something else? Even for selected cells will make it so much easier! the original is :…
