-
COUNTIF substring or wild cards
I have a column of Part Numbers. Each cell in the column may have a single part number or comma separated part numbers. I want to count the number of occurrences of a particular part number in the column. I searched the help and community pages but wasn't sure what's the latest. Is it possible to use wild cards or any…
-
Formula referencing cell in newly submitted row
Hi all, I fear this may be impossible, but it's always worth asking. I have a simple time logging sheet with a web form that just asks what project a user is working on. I have system columns use the time stamp from the web form to log the time. I am trying to use the difference between the submitted time and the last…
-
LOOKUP & MATCH together
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…
-
Does the autofill formula feature not work on project sheets?
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 percentage a resource is allocated to each project?
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…
-
Shade every other row in Grid View
How do I make my grid view smartsheet to automatically shade every other row a different color background so it's easier to read?
-
FORMULAS (SUMIF?)
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…
-
Seeking an Alternative to the Absolute Reference of a Parent Cell
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…
-
Enhancement Request: relative addressing for cell linking in sheets, reports and sights
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…
-
Dates Don't Act As Dates if Linked from Another Smartsheet
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…
