Hi everyone, I use a VLOOKUP and MATCH function in Excel to find the intersection of vertical and horizontal values (intersection of a matrix / table). I can't seem to get this working in Smartsheet and need some help. For example if I have Likelyhood = Likely and Impact = Moderate then I want the Criticality to return the…
When I create a blank sheet to test the autofill formula feature, it works well. However, it does not seem to be working on my sheets that are project sheets. Anyone have any insight on this?' TIA
How can I calculate the number of days or allocation percentage a resource is assigned to a project? What I'm trying to understand is the percentage a resource is allocated to a project so I can track the total in a master project list. For example, if a resource is assigned to 3 projects and they are aloocated 25% per…
How do I make my grid view smartsheet to automatically shade every other row a different color background so it's easier to read?
I have a task line 'Total Commission Percentage Earned to Rep'. As you can see, right now it says 10.03%. I need a formula that max's that percentage out at 10%. Sometimes the 10% will change to 8% ('Commission Percentage Allowed to Rep') and that will need to max out at 8% as well (the other 2% would go to 'Commission…
Has anyone used a formula which can report a child's percentage of the total rolled-up in its parent without using absolute cell references? I'd like to avoid absolute references because I'd like the formula to be consistent all the way down many parent cells, which will have different absolute references to be used in the…
It would be great to be able to use relative addressing in cell linking between sheets and links in reports and sights instead of the fixed linking as currently implemented in Smartsheet. Why? We use Smartsheet for project management and have a set up a standard workspace which contains set of sheets/reports and sights…
In short... if I pull a date from another sheet using "Link from Cell in Another Sheet", I can't do formulas off that date. I've verfied that the columns are formatted as dates. [Opening Date]1 is linked from another Smartsheet. I want to add 180 days to the [Opening Date]1. [Opening Date]1 = 08/22/82 Here's what the…
I'm hoping to find a formula I can use to automatically fill out the parent row's progress bar based on the child rows. The result would look something like this, just not sure if this is possible. * * Section 1 is 50% because: Sub-task 1 + Sub-task 2 + Subtask 3 = 150 then / 3 tasks = 50% progress bar Section 2 is 75%…
Hi Everyone, I am relatively new to smartsheets and there are two things I have been trying to work out adn for the life of me can not find the information to show how its done. The first is having a field aut populate based on picking a contact e.g Contact name = Gary Bee then the next cell should auto popolate with Gary…