-
Master Sheet with Subprojects Inside
Hi! I am trying to create a Master Project sheet that would include subprojects inside of the same sheet. Basically so I can track the dates and overlapping of tasks in the subprojects. Is this something that Smartsheets can do? I know I can do it in MS Project and just add each subproject as it's own task in a master…
-
Apply Formula to Entire Column
I'm trying to automatically apply a formula to an entire column that concatenates info from cells in a given row into a document name, once data is entered into those cells. The only way I've been able to accomplish this so far is to just copy/ paste or drag the formula as data is entered in a new row, but I'd like it to…
-
Help! Percent Complete not calculating
I have a project plan that was sent to me in a Excel spreadsheet that I'm trying to import into Smartsheet; after some trial and error, I've fixed up the fields but even with duration, start, end date and predeccesors enabled, I cannot get the % complete column to populate.…
-
Column descriptions - display
Is there a way to keep column descriptions displayed instead of having the user hover over the icon?
-
Conditional Formatting with multi select dropdown list
When using Conditional Formatting, I want to make my primary column change colors when a combination of choices are made in a multi select dropdown,. What it looks like now is this: If column 2 is 'condition' and column 3 contains 'condition one' or 'condition two' then apply this format to the column one Is there a way to…
-
Limited Availability on drop downs in forms
Hi, relatively new user here - I am wondering if there is a way to make a drop down option limited? Like for appointments or meetings? example: Choose a time slot - but only ones that have not yet been chosen will display? Any help is appreciated!
-
Automation for expiring dates
Hello, I'm trying to create an automation for a coloum of expiring dates. Each row is associated with a different email, so when the date for their insurance is expiring in two week I would like to sent out an automatic notification to that email address associated with that row. Is this possible?
-
Auto fill information in sheet when a check box is checked in a different sheet
Hello All! I am trying to figure out how to auto fill information into my sheet, when I check a box in a different sheet. I am keeping track of different invoices and sponsorships in the original sheet. When I check a box in the column "Ad" then I want the "Organization", "Event", "Start", and "Due" columns to auto fill in…
-
cell.format currency settings
I'm able to successfully format a cell through the API and the compact format string, cell.format (https://smartsheet-platform.github.io/api-docs/#formatting,) except for cells with currency formats. I would like to see an example of the cell.format that works for submitting 123456 as the value/display value and a…
-
Connect email notification with smartsheet for specific users
Hello, i was looking to create a new project using smartsheet to receive alerts from specific email addresses and to log the activities into smartsheet, those notifications will be received by specific users (their email addresses). how i can start implementing that and is it doable or not? Thanks!
