Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums. Archived 2016 Posts
Archives for September 2016
Discussion List
How can I count just Blank child cells?
I can make the formula work if the cell has a number in it but not if it is blank! I've nested IF statements until I'm blue!!!
Total count based on values from two columns
Hello, I'd like to check the text in one column and a check mark in the second column and then get a total count based on that. The first column is Scope which can be A or B. The second column is complete which is a checkbox that's either checked or unchecked. What I'd like the formula to do is check the Scope column. If…
Count IF multiple criteria
Hi - I would like to have a formula to count items based on a couple of criteria - Status and Deliverable. I have attached a picture of the columns.
Determine RYG ball color based on rows below
Hello, I'm trying to write a formula that'll allow me to look at the color of the RYG balls in some rows, find the lowest color and set that as the main color for the overall project. So, Project A needs a status. I'd like to look at tasks 1-5; if any of them are red, the entire project status needs to be red. If any of…
SS Anonymous
Hi SS users, i have been a user of SS for just four weeks and i need to know if there is a self help group for addicts! my first waking thought is about our SSheets and who is collaborating with who and i get excited at the thought that we are getting efficient at work and that we are actuallyu joining up the dots at…
Predecessors without adjusting date?
I've searched the community/help and haven't found a good solution so I'll ask here. There are tasks that have proposed start and finish dates. I have a duplicate task that will show what the actual start and finish dates are because of delays and such. Currently the duplicate has the same start/finish as the original and…
Mark Complete If column value is 100%
Hi Everyone, I'm trying to write a formula to mark a status column one of the following based on a % complete column: Complete If 100% Not Started If 0% In Progress If 0<>100% Empty if blank I'm using: =IF([% Complete]1 = "100", "Complete", IF([% Complete]1 = "0", "Not Started", IF([% Complete]1 = "", "", "In Progress")))…
Help needed
Hi , I need help if anyone can assit me , I would like to create a new sheet (Call it A) with dates / times in different columns then from another sheet (call it B) be able to see any times that are available in sheet B. I currently have a loading shedule with collections every 2 hours and have issues with multipul…
Days Since (Single Date)
I have to do some invoicing and want to know how many days since an invoice was issued. I can sort out how to find the days between two dates but I only have one date to work with here. Would love if someone could help!
Gantt Chart - Show Repeat activity every fortnight / month etc
Hi All I am wanting to show an activity that needs to happen every week or month on a Gantt chart in one row. Any suggestions please?