-
Formula # UnParseable?
I have a Smartsheet 4 columns are check boxes. I want the check boxes to change a list column to the following. If I check on Assigned then change list to Assigned If I check on In Progress then change list to In Progress If I check on Holding-See notes then change list to in Progress If I check on Complete then change…
-
Can you move entire rows based on colour?
For example, I have a sheet that contains multiple tasks. Once the task is completed the row containing the tasks information will change to green. I would like to then move all green rows into another sheet to produce a sheet of completed tasks. As tasks are added and completed each day, I am looking for this to be an…
-
Having Issue with "COUNTIF" returns "0"
Hi Guys, I have to count the status. Let's assume I have 5 different statuses (0,1,2,3,4) in another sheet. I have prepared a separate metric sheet to count the status specifically for a date range but I got the result as "0" for everything. I have tried to change the name to execute but that doesn't work. can you please…
-
Formulas & Filter Assistance for a To Do List
Hi, I have tried a few searches and haven't quite found what I need to perform the function within my smartsheet. Hoping some of the Formula wizards can help me out. I am using Smartsheet to manage my to do list. The filters are great but only make allowances for 1 or ALL conditions, I require 2. I am wanting to create a…
-
Flag if date range across weekend
Dear Smartsheet, first, great product and I have been able to learn alot on this forum....however I am a little stuck with a function/formula. I have a list of tests which is dynamic and changes frequently due to predecessors. I would like to be able to Flag column "Weekend Run" if the test date range occurs over a weekend…
-
Updating parent status from child rows in separate columns
Hello. I'm looking for a formula to update the Project Type column in a parent row to identify as "Digital" based upon specific contact entries in the Assigned To column in the child rows. For instance: -child row Task 1: Assigned To Employee A -child row Task 2: Assigned To Employee A, Employee B, and Employee C -child…
-
Calendar Displaying blank fields
I am trying to create a smartsheet calendar off a workplan, and am running into the following issue. I don't need all the items from the workplan to populate on the calendar. My main column is [task name], and for some rows, I have an associated [event type] in another column. I only want the calendar to populate the rows…
-
Gantt Chart/Graph
I have put in the dates for the task and can not make the excel file show a gantt chart/graph for the project. I have even deleted and reopened a new file and I can not figure it out. Any help is appreciated. Also, I am using a Mac if that makes a different.
-
If-then-else
trying to get a formula for a risk register. Tried the below but cant get it to work =IF({Risk Rating}@row<= 6,= "No significant impact") or =IF(Risk Rating @row<= 6, "No significant impact") once I get this right, I can add the other ifs.
-
Network days returning negative number
Back again to ask for some wonderful assistance. Formula works great, except for 1 value it's negative - I am completely lost as to why. Double checked if formula consistent, and it is. So NO CLUE. Any thoughts?? =IFERROR(NETWORKDAYS([IRB Submision Date]@row, [IRB Approval Date]@row), ""