-
IF Y is blank, and X is not, take Date of X and add 90
i know this is not correct.. but. can someone help me fill in the missing pieces. =IF(ISBLANK([Renewal End Date]@row, [Agreement End Date]7, +90)) my goal is to have the Next Review column produce a date that is 90 days from either the renewal end date (if there is one) or the agreement end date Thank you in advance!🙏
-
Expected Progress
Hi, which formula can I use to calculate the expected Progress (depending on the current date)? Thanks
-
Is it possible to create a conditional rollup for $'s OR display the max value for %'s?
I am working on a smartsheet tracker that can track the cost savings of specific projects on a month to month basis, then rolls up the total YTD savings. There is also an option for the users to enter their project progress as a percentage, in which case I would want the YTD column to display the maximum % from the year…
-
Total Cost Based on Date of Task Being Finished
I am working on charting out dev tasks and need to display what our expected total monthly cost would be based on the tasks finished each month. I am struggling to find out a good way to have this either permanently displayed or easily accessible. I have tried reports but that only displays all of the costs and does not…
-
How to make COUNTIFS formula to count separately?
Hi guys, I have a question regarding the COUNTIFS formula. The following is my problem. I would like to count the projects, which have the project status "In Progress". For each of my 10 projects, I have a separat folder with the same sheets in it. In every sheet "10_Project Metadata" I have linked the project status (Not…
-
INVALID REF Issue
I am using the following formula and having intermittent #INVALID REF issues. Every few minutes (most likely when the formula is refreshing) it will show #INVALID REF. If I open the sheet and then refresh the formula fixes itself for a few minutes before erroring out again. Any suggestions? The first COUNTIFS formula is…
-
INDEX/COLLECT FORMULA PUSHING OUT "#INVALID VALUE" - CAUSING CHECKBOX FORMULA TO FILL IN WITH SAME
I'm trying to gauge training impacts for different business areas within my organization for specific projects. I have a sheet in the background that's pulling if the business area has marked if they have a "training impact" or not in relation to a specific project. Example: Business Area 1 responded "Yes" to having…
-
Copying Date columns and making them editable from reports
Hi, Back again with what I hope is a simple fix. Background - I am creating a global project tracker, used to manage and maintain over 2k current projects and ~100 new/ intake projects on a monthly basis. Requirement - The intake form feeding the SmartSheet is asking for a Start Date (intake), Launch Date (intake) and…
-
Formula Challenge
Hi Smarties, I am trying to get this formula right in the Formula Challenge from Smartsheet. I am not sure what I did wrong so hoping fellow Smarties could help! In the Parent Row symbols column, write a formula that returns the most common value of its children. If there are equal or more reds than yellows or greens, the…
-
IF Condition issue
Hi, Can someone help me why i am just getting the value as Quarter if i change the value to less than 25 in column =IF([1.1 Landscape]1 > 0.0025, "Quarter", IF([1.1 Landscape]1 > 0.005, "Half", IF([1.1 Landscape]1 > 0.0075, "Three Quarter", IF([1.1 Landscape]1 > 0.001, "Full", "Empty")))) THanks