- JOINARRAY() function Idea
=JOINARRAY([End Delimiter],Range 1, [Range 1 Delimiter],...) *No delimiter for last range listed. =JOINARRAY(", ", A:A, " ", B:B) results in: x 1, y 2, z 3 blank values are ignored, hence the over-ride for the end of the item delimiter
- 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
希望有人能帮帮我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.
- Formula - Return month as text from a date cell.
I want to use the formula: =TEXT(*CELL WITH DATE*,"mmmm") But this doesn't seem to be a valid formula on Smartsheet. So if I have a cell with the date "01/01/19" - I want it to show "January" in another cell.
- How to extract just the month name from a date
Hi all, I'm trying to extract month name from the date column. It has been giving me an error. Any input will be highly appreciated.
- Row numbers
Hi, I have seen multiple threads around this but still I'm surprised there is no dynamic solution for this, I have tried auto populating ROWID by AutoNumber column and as you can see in screenshot whenever I try to add a new row in between it calculates the row number from the bottom (WOW), this is very bad and this is…
- 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,…
