-
Can someone help me create % complete by using date and checkboxes?
The previous calculation I used to calculate % complete is by strictly referencing if a date is in a cell. I would like to use a combination of Date and checkboxes to determine % complete. Previous working formula, using only dates: ((COUNTIF(ISDATE([Field work % Complete]@row), "1") * (1.8) + COUNTIF(ISDATE([Engineered…
-
If Function between different sheets
I'm trying to get an if function or something similar to work here. I have two different sheets and I'm trying to match an ID number. If the ID number appears on both sheets, I want the cell value to return with "Yes" and if not, "No". For example, this is the formula I currently have: =IF([ID Number]1 = {First Year…
-
Dynamic vlookup for milestonetracking across multiple projects
Dear community, I currently need to track budgets for several projects which are linked to certain milestones. To simplify it a lot , there are two Smartsheets. 1st Smartsheet - Contains all projects with a monthly budget. E.g. Project X needs to complete the Pilot phase with X amount of budget until the end of April. 2nd…
-
Enhancement Request
Hello, I have a few requests that would enhance my Smartsheet productivity that may be useful to others as well. Please redirect my post if this is in the wrong area since it has been a while since I've posted if at all. I understand that some of these features may be available in the premium add-ons that Smartsheet…
-
Convert Symbols to Numerical values
What is the formula to convert the bar symbols of Empty, Quarter, Half, Three Quarter, Full to numbers? For example, Empty = 0 Quarter = 1 Half = 2 Three Quarter = 3 Full = 4
-
Problems with formulas
i am having difficulties with my formulas . I am trying to acheive the following: IF status row is not "complete" AND due date is Today or in the past, if true Flag, if not unflag. My formula is: =IF(AND(Status28 <> "Completed", [Planned Finish]28 >= TODAY(-15)), 1) However this is the results - it is not calulation what i…
-
Nesting Formula for RYGB
Can anyone help me with a nested formula: I need the date to populate if the RYGB is yellow or red only. Formula works for one if I "not" green, but I want it to be if not green or not blue: =IF([Exposure Category]2 <> "Green", [Last Date of Exposure]2 + 15, "N/A") Can anyone help?
-
Can a (date) cell be locked once data gets entered thru a Dynamic View???
Hello, I have been browsing around both the active and archived threads but have not been able to find information even similar to what l'm looking to do: I am trying to have a field (Estimated Start Date) to get locked and show as read-only in a Dynamic View once a date it's entered in the corresponding field by the…
-
Changing the question
Third time lucky.. editing this post (lets go by the ordering of column 1 , 2 , 3 , 4) How would I formulate to achieve: When there is no date in Column 2 I would like Column 4 to continue counting But, once Column 2 has a date entry in it, I would like Column 4 to stop the count on that point is this possible ?
-
Counting open tickets based on company name and ticket status
Hi, I'm trying to count the number of open tickets by company name, and the cells I'm referencing are in another sheet. Here's my formula so far: =IF({Maintenance tracking Sheet Range 2} = [Company Name]@row, COUNTIF({Maintenance tracking Sheet Range 3}, {Maintenance tracking Sheet Range 3} = "Open")) But I'm getting an…