-
Automatically including new rows in formula
Other than SUM(CHILDREN()), what's another way to include newly added rows into formulas? My scenario is this: I have a parent with multiple children, and new children are guaranteed to come in. I want to sum a column based on the condition of another column. How can I use the SUMIF to include newly added rows without…
-
Cell value if there is an attachment?
I would like to add a cell that will show certain text if there is an attachment to each row, is this possible?
-
Scheduled Dates
I am a Project Manager working on a project plan for a technology company. I estimate dates based on the initial project kick-off date. I allow a certain amount of days for each process step. Example: - Kick-Off Date = 01/01/2017 - Estimated Development Start Date =[Kick-Off Date] + 7 = 01/08/2017 - Estimated Development…
-
IF/AND Statement to yield check box answer
Hi Smartsheet wizards. I am trying to create a formula for the following logic to track my teams contact with clients. Essentially if a team member hasnt contacted a client within 30 days, to produce a check mark. We have a small team so I planning on copying this formula to a seperate column per team member and then…
-
Totals by Month using a date column
Is there a formula to count the # of entries for each month, using a system created date column? It seems like this doesn't exist unless you create a new column that says either 12 or December by looking at the date column.. thanks!
-
Setting RYGG Based on 2 Columns
I'm trying to set up RYGG based on a Finish Date column and a Status column. Here is what I have so far: =IF(Finish6 < TODAY(), "Red", IF(Finish6 = TODAY(), "Yellow", IF(Finish6 > TODAY(), "Gray"))) What I would like to accomplish past this: Yellow if 5 days prior to Finish Geen if 6 or more days prior to finish Gray if…
-
Nested ISBLANK Formula issue
Hi all, I've having some issues with the formula below and was wondering if anyone more knowledgable than I could take a look for me. I don't get an error message I just get a blank cell which is actually worse than an error message. =IF(ISBLANK([WPA2]47), [WPA1]47 + [>30PEE]47, IF(ISBLANK([WPA1]47), RCM47 + [>30PCM]47,…
-
Can Smartsheet show a Gantt style bar that shows monthly RAG status trend?
I am new to Smartsheet and have a POC developed in Excel that allows us to have a gantt style timeline that is coloured by month according to the monthly RAG status. This RAG status is conditionally formatted based on whether we indicate 1, 2 or 0 in the cell but is not shown. We can also add activity descriptions in the…
-
Using Percent Value to Set Dropdown
I am trying to use a formula to set a dropdown value based on the percentage value. Here is the formula I am using: =IF([Percent Complete]7 = 0, “Not Started”, IF([Percent Complete]7 < 0.26, “Just Started”, IF([Percent Complete]7 < 0.74, “Working”))) I am setting the formula in the dropdown cell and continue to receive…
-
Is there a formula to check one checkbox for a row that will check other checkboxes throughout the s
I am creating a sheet that contains the same item on multiple rows and need a way to link the checkboxes, so if one is checked all are checked. Please help!
