-
Formula for Status
Hello, I am trying to create a formula to automate the 'status' row in my project grid in SmartSheet. Here is what I am looking for: Actual start date = Blank, show "Not Started" If Actual Start Date = is a date and Actual end date = Blank, show "In Progress" If Actual start date = blank and projected start date > today OR…
-
Conditional Formatting
I have never had this issue but currently I have conditional formatting set to make a cell 'red' if the due date is in the past. The date is calculated based on a formula from other cells but this is a date column. The conditional formatting will not work. I have several dates in the past and none are following the…
-
Report Grouping Work Around
I have a list of SOPs and their supporting documents (Forms, Logs etc). As you can see in the Excel example, we have the SOPs in Green and the supported docs below. Some, like the SOP Training/Retraining Record, are used for multiple SOPs. I tried: Using Gantt functions, added a Predecessor Column but I couldn't run a…
-
Formula returning 0
Hi Can anyone help me with this formula? Should be really simple, but i am having an off day it seems! The formula is looking for any elitebook g3 devices that are in northampton, but gives me the result of 0 instead of the correct number? Any ideas?
-
Automatically Track Inventory Usage
I'm new to smartsheets and am not an excel expert, but I've been building some sheets and workflows and have a question about more advanced capabilities of the program. I'm hoping there's a way to automatically track inventory usage based on information input into a separate smartsheet form? I have two sheets: one is the…
-
Formula for 2 columns - checkbox and a date range
Hi there - newbie here. Looking for help with a formula. I am trying to drive a metric which shows the percentage of activities on 'THD Brands' in the past week. The 'THD Brand' column is a checkbox, so essentially I need to count anything that is ticked in this column, and also the 'Last met?' column has a date within the…
-
IF AND INDEX MATCH to pull the correct row based on criteria
Hello all, I am struggling to come up with the correct formula to pull the right information between master sheet and personal tracker and I wondered if you can help. My logic for creating the formulas is not the very best. What I'm essentially trying to do is pull the right start/end date and budgeted hours from the…
-
Logic Project Plan
Hi , Need a help on the project plan logic related to Sch Health. The logic i am using on the schedule Health is not showing me the correct result. As you can see Start date is 06/01 and End Date is 06/30 the % Complete is 50% ideally it should be green because it just a week and the % complete is 50% Can any one help on…
-
I need help so that I can calculate a percentage of completion
Guys, I need some help. I am struggling with calculating the percentage of completion of the whole sheet based on how many tasks are Complete in the Status column, or maybe better said to calculate the completion percentage based on the Parents Status in the Status column. Thank you and I am waiting for your advice.
-
Need Help with an INDEX(Match) formula
Hello, I need some help sorting out an INDEX(match) formula that is not working despite my best efforts. It may be that I have been staring at it too long. I keep getting a No Match when I add "0" in search type, and I get the first value in my column when I add a "1" in search type. It seems ot be returning the first…