-
baseline - actual dates
This post is in regards to this post below. I would like to get in touch with Jeremy michels to see if he will share the sheets he references with me.Any help will be appreciatedThanks so muchLouise Jeremy Michels601 ptsApril 5, 2015 8:30 pm I do the added columns now. We use it for both schedule and budget reasons. If you…
-
Formulas and Sheet Saving
All of the sheets in my solution have a date column for "Today". =TODAY() I use formulas in several other columns to determine if the checkbox column for Current Qtr should be checked. (same for Previous Qtr and Next Qtr) I use the checkboxes in report filters. Problem: Because my formulas are updating sheets daily, I have…
-
How do I use an OR function with a simple IF function?
I’m currently using this simple IF function (If Team Column equals “Undergraduate Robing”, check the box (formula below) but I need the box checked if the team column equals “Undergraduate Robing" or “Faculty Robing” or “Marshals”. Is this possible? Current Formula: =IF(Team1 = "Undergraduate Robing", 1, 0) Any assistance…
-
Formula Help-Finding the minimum value greater than zero
Hello Smartsheet Community, The formula I used in Microsoft Excel needed to be entered as an array. What is the best way/formula to find the minimum value in a range that is not zero?
-
Formula
I'm trying to build a formula. Date range based off Finish date. Currently I have a date in the Finish date cell and it will populate a text based off the finish date but I really want to do a date range now based off the finish date. Example below the date range would be 02.01.16 thru 09.30.16. Can someone help me?…
-
Nesting Formulas
I need some help with nesting formulas for the following screenshot: What I'm trying to accomplish is an automatic change in the "Status" Column based on the following criterias: 1) If "%Complete" >= 1% and "%Complete" <= 99% and "At Risk" = 0 then "Status" = In Progress 2) If "%Complete" >= 1% and "%Complete" <= 99% and…
-
Excel formula =SQRT()
I am looking for a similar foruma to =SQRT() in Excel. Does Smartheet have this feature/function in its formula list?
-
Graphic for pipeline
Hi, I am an architect and I NEED to see all the data graphically. I am looking for samples of project pipeline graphics produced using Smartsheet. Please, post them here or send me a link. Thanks! ileana
-
Tracking Assigned Tasks
Dears, How to view a specific person tasks on smartsheet, i assign multiple tasks for multiple users so what is the best way to keep informed or to check the update of a specific person tasks. Thanks.
-
SUM Parent without Children?
I've been able to figure out how to SUM children under parents, but is there a way to SUM just the parent rows? For instance: NAME NUMBER Parent: 10,000 Child: 10 Child: 10 Parent: 10,000 Child: 10 SUM (Parent only): 20,000 I'd like to do this without selecting each cell if possible so it'll update whenever new Parent rows…