-
Drop down menu
Can I use a drop down menu to auto fill line item onto another sheet? or can I have another sheet have a rule that says "if drop down menu reads dept.#2 fill in information drom another sheet"?
-
Calculate % complete based upon start and end dates?
Hello, does anyone know how to calcuate the % complete for a project based upon it start and end date? I have projects where my resources are "consulting" and I'd like to have a way to see the % complete of the project when I roll it up in a project overview dashboard. I tried using the traditional "yearfrac" formula…
-
Nested IF Formula - Date Error
Set up a basic Nested IF that does nothing more than display the mailer round status based upon a set of dates entered. With no dates inputted the formula displays the correct value, however once I input a date it returns "INVALID OPERATION". I've attached a copy of the formula below for commentary. Appreciate the help.…
-
How can I make a "Status" field change "Percentage Complete?"
Hello, I'm wondering how I can sync a dropdown menu (Status Column) to another column (Percentage Complete). Ideally, this function would change the Percentage Complete column to 100% when the status is marked "complete." Thanks in advance for your help with this! - Mike
-
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…
-
Nested Formula
How can I implement an IF/AND/OR formula to calculate the desired output? For example: if an item type=ROM Estimate AND accuracy>50% OR <-30% then YES, NO. OR if item type=Budget Estimate AND accuracy>30% or <15% then YES, NO OR item type=Definitive estimate AND accuracy >15% OR <-5% then YES, NO Any help would be…
-
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…
-
Feature Request: Timeline within Smartsheet
One feature that MS Project had that I've had a hard time working around is a timeline feature that is part of the application. I understand that SS integrates with Office Timeline, but I have to pay for this, manually manipulate this, and I have to recreate a timeline each time deliverables change on my plans. We have a…
-
Workspace Project Tabs
I have searched and cannot find the answer to my question. I have several project tabs open but when I switch from one to another, it last tab will arbitrarily change to a different project from my Sheets list. (I have marked some as favorites hoping this would keep them open but it doesn't.) I then have to go to my Sheets…
