-
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…
-
#INVALID DATA TYPE when using COUNTIF Formula
Hey Community - I am having an issue trying to use the COUNTIF formula. In this use case, I basically have a formula in the first column to show if start and end dates match with other columns in the sheet. All I want to do is count the number of "Yes" cells, but when I try to use the COUNTIF formula, I get an #INVALID…
-
countifs + find formula with multiple criteria
Hello, I'm fairly new to smartsheets and trying to solve a roadblock. I'm trying to count the amount of times a specific string is in a cell with two types of status: closed and submitted. I'm using the FIND because some cells contain more than one ticket # (i.e. "Ticket-432, Ticket 12435") =COUNTIFS({Database Range 1},…
-
Count of All Items, where Start Date is less than Today
Hi, I am trying to get a count of all Task Named: "To Do", where "Start Date" is less than Today's date. I am using: COUNTIFS(Task Name, "To Do", StartDate, "StartDate < Today()"), for this, I keep getting '0', but I see there are at least 4 tasks meeting this criteria. Any help if very much appreciated. Thank you, Deepthi