Thank you in advance! John
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…
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…
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…
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?
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?…
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…
I am looking for a similar foruma to =SQRT() in Excel. Does Smartheet have this feature/function in its formula list?
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
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.