-
Automation / Update Request
Is it possible to set up an Automation / Workflow which will send a weekly reminder of any Update Requests that haven't been completed?
-
Auto populating data from another sheet
Hi, What is the best formula to use for auto populating a same field data from another sheet based on a project ID #? Please advise. Thanks
-
Fit charts?
I am having trouble formatting my charts. Is there a way to fit the chart to a specific size without the labels going diagonally or some of the data labels to be cut off? I've moved the legend around and changed the font size to the smallest available (8), but any other tips would be appreciated!
-
Shared Tasks from Outlook to Smartsheet
Good Morning, So I am trying to move our Outlook tasks into smartsheet. My question is, does anyone know how I can import them into Smartsheet? One problem is that the tasks are shared to me, is that a problem? Thanks! Jovani
-
Counting number of submissions and various stages
Hi I'm new to Smartsheet and trying to figure out ways it can help me keep track of the work we have ongoing in the department. At the moment I have an excel spreadsheet where I enter every new submission to we make to an outside authority, a new line when it is validated and then another when it has been approved. My boss…
-
RYG Formula Average
Is there a way to take the average of the RYG colors and roll it up to an overall summary for a section and then the overall section to the overall project summary? I've included a snapshot of what I'm talking about.
-
Only perform calculation if cell is not blank
I currently have a sheet and one of the functions I want is to check a box if the Date Won/Lost is older than 365 days. My current formula is: =IF([Date Final (Won/Lost)]@row < TODAY(-365), 1, 0) However, when the Date Won/Lost cell is blank (because the contract hasn't closed or been abandoned yet), the formula returns a…
-
Checking as check box if 2 criteria are met
I am trying to check a checkbox if the name and date on another sheet are on the sheet. Here is the code I have which is obviously not working. =IF({2019 IA Tracker Range 2}, 5 / 23 / 19, {2019 IA Tracker Range 1}, [Vendor Contact]5, 1) Where range 2 is the date and range 1 is the name. Any help is appreciated.
-
NETWORKDAYS using two different sets of holidays.
Hi, Just wondering if its possible to use the NETWORKDAYS formula using two different sets of holidays, based on whether testing site is Munich or Sydney. I have the holiday dates listed in separate columns e.g =IF([Testing Site]10="Munich", NETWORKDAYS(start_date,end_date,munichHol1:munichHol13), IF([Testing…
-
Dependency from a cell on another sheet
Hello, I run my manufacturing jobs on Smartsheet. I have one sheet with multiple projects on it, Parent row per project and tasks indented I have a few milestone dates in each project for equipment arriving (this date is linked from a shipment tracker) which other task tasks within the project are dependent on before the…
