-
Trying to do logic if first character is a number, IF(ISNUMBER(LEFT... seems to always result in FAL
I want to do some logic based on whether an entry starts with a number. I assumed `=IF(ISNUMBER(LEFT([Primary Column]1)), "Number", "No Number")` would have worked, but it seems to always return FALSE. What am I missing? (Also, does this forum not support tables or code formatting?) | Primary Column | Formula | Result |…
-
COLLECT Formula for Contacts
Hi there! I am trying to set up alerts for a smartsheet document to notify any contact that does not have a specific row updated. I have two columns that I'm currently referencing in the sheet, and I'm hoping that I can have a cell return any and all contacts in a column selection that does not have that box check. The…
-
Help with a Formula
I have a Target % Complete column in a project plan template that essentially looks to see if you are tracking to the % complete you should be based on today's date and the start and end date of any task (or tells you that you are missing dates). I've included the formula below that returns the result of what your target %…
-
Decimal Rounding + Adding letters to formula
Hello! I'm trying to have this formula round + add a "w" to the end but I cannot seem to figure it out. The formula is: =(Due1 - Due@row) / 7 + "w" I would like it to say 12.9w but it keeps saying 12.85714w and I've tried using the "Decrease Decimal" option and it does not work. Due1 = 2/24/20 Due@row = 11/26/19 90-day…
-
VLOOKUP #INVALID DATA TYPE Challenge
Hi! I'm new to the community and already raising an issue. Sorry about that! If anyone can help me with this, I'd greatly appreciate it. I'm trying to use VLOOKUP within a Product Roadmap sheet to set the values of the feature start date and end dates based upon a Sprint it is assigned to, referencing a set of scheduled…
-
Permissions to edit cells
Hello all. I have several work flow sheets, in which collaborators have to change the status of the tasks, but not all collaborators could change any status. The question is possible edit permissions on cells to avoid that any user could change it? Thanks
-
Nested If with Multiple Conditions Automation for Project Management
Hi SS Community! Had a complicated question and my formula keeps coming back unparseable, so I wanted to run this by you and see if anybody could help me. Currently, I have this: =IF(AND([Start Date]@row < (TODAY() + 14)), NOT(OR([Status]@row)="Complete"), ([Status]@row)= "In Progress"),"On Deck", "Not Started") I just…
-
NEW ZEALAND TIME ZONE & TODAY() function mismatch
Hi Smartsheet Team , I have an issue with the Today() function not reading my date correctly . I contacted you and you provided me with a long formula to overcome this but it still didn't solve the issue for us . The formula i'm using now is : =IFERROR(IF(AND(ISBLANK([Resolved Date]@row), [Created Date]@row <= TODAY()),…
-
IF AND Function For Reporting
Hi guys, I am trying setting up a new report for my team which will allow them to bring through project activities based on the following criteria: * The week the activity happened in is before today's current week. * The RYG status is red OR green OR yellow I am using a column set up as a checkbox and trying to put an IF(…
-
Countifs function to count ratings by location within the past 7 days
I am trying to create a countifs function to count 5-star ratings by restaurant location published within the past 7 days. The published column contains dates. So far, I have this equation: =COUNTIFS(Rating:Rating, =5, Location:Location, "Bayshore", Published:Published,AND(@cell <= TODAY(), @cell > TODAY(-7)) I am getting…