-
RYG ball to determine priority involving multiple dates
I have a sheet that lists all active contracts for my department which all have expiration dates. However, I am struggling with this sheet because in all calculations I need to consider any extension dates. I do fine with calculations when there is one date involved but when I need to write them to incorporate two and…
-
Calculating years of service
Hi there! I have a sheet that we use to track key dates for staff (anniversary date, years of service, etc. etc.) I have a formula that seems to be successfully calculating the years of service, but when I try to set this as a column formula I am getting an error message (and the help article really isn't helping). :( Here…
-
Transfer ownership of Workflows
Clarification required : I have transferred my Workspace to my colleague. The sheets have workflows build for notification which still carry my email id since I was the creator. Can that be fixed and these notifications go out using the new owner email id.
-
Explain =IF([Schedule Delta (%)]@row > 0.1, "Red", IF([Schedule Delta (%)]@row > 0, "Yellow", "Green
Good evening all, Can you explain what this formula is actually doing? This is the standard formula that is in the project plan in the Smartsheet PMO template. I think it should change "red" if my task is behind schedule. None of my late tasks are turning red, the project plan remains green for everything :-( Please help…
-
combining vlookup with sum formulas
Hello Everyone, I am stumped again like usual and looking of help with getting a formula right. I am creating a data analysis sheet to generate sums and averages based on another sheet which has raw data. I understand how to do a sumif formula and separately how to write a vlookup formula, but I am struggling to combine…
-
Change progress bar to full once checkbox is checked
Hi, I looked around at a lot of other similar questions but they were all for really complicated formulas that didn't apply- I tried doing this with a mix of automation and formula, but no such luck. We're building a to-do/ task sheet, and all we need is pretty simple- we want to be able to manipulate the progress bar…
-
Using COUNTIFS With Contacts, CONTAINS, and OR
I'm essentially trying to make a sheet summary formula for how many open cases someone in a contact list has at the moment. I've got it working when I'm looking at the contact list one way, but the users of this sheet have a bad habit of entering data so that their email address displays in the contact list rather than…
-
Sum(Children()) and Sum(row:row) not totaling correctly
I created a sheet to itemize costs on furniture orders. I used a hierarchy so I could just use =sum(children()) to see the total costs of each project. While the first project totaled correctly, the second is coming up with an additional $2919.36. First I went back to ensure all of the figures are correct, and they are. I…
-
Return a list of cell values if one criteria is met
Hello, I would like to return a list of Project IDs (four digits) that meet the same criteria , so I went for : =JOIN(COLLECT({Project Summary MASTER Range Project}, {Project Summary MASTER Range Time}, "Yellow")) Unfortunately, it comes back as an 8/16/20 etc digit long without any separation - is there either 1) an other…
-
Creating a master budget file from multiple project budgets
I am trying to create a master budget file for tracking budgets and spending across several sheets, but I am struggling to come up with a solution that would enable me to drag the cell references across, like you can do in excel where it dynamically changes the cell reference. The sheets are structured with a budgetline…