-
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…
-
RYGB - need to update Parent row with status of children
I am trying to get the Status in the Parent row to update automatically based off the Status of the child rows. I have the following formula in the Status column of the child rows: =IF([Phase Status]@row = "complete", "Blue", IF([Phase Status]@row = "At Risk", "Red", IF([Phase Status]@row = "On Hold", "Yellow", IF([End…
-
Help with Formulas
Hello! I’ve been using Smartsheets for a while now, but am new to building them. I am having trouble working with formulas to identify current status of my tasks. I’ve searched the community and have tried out suggestions based on previous responses, but I’m still stuck. I’d be grateful for help sorting out the following:…
-
Nonworking Days but tasks must be completed
So I'm setting up a smart sheet so that I have a holiday break for Christmas and Thanksgiving. My problem I'm having is that when I go to start one task after the next, it'll start a task and carry it through the holiday break then complete it after the break. Is there a way to set it so that if a task won't be comlpleted…
-
Copy/clone a column WITHIN a sheet
Hi, I see lots of information sating you can't copy a column from one sheet to another. I want to make duplicates of a column WITHIN the same sheet. Is this possible? The reason is that I have a long dropdown list and some cell (not row) conditional formatting in a column which will be the same for all 7 columns and this…
-
Date is Within the Next 5 Days
Hi Smartsheet Community, I'm authoring a production schedule and one of the columns automatically populates status (complete, in progress, not started) based on a formula. For a specific row, I need it to display "In Progress" if the start date is within the next 5 days. Is this the correct formula for this? =IF([Start…
-
Countifs: Using a reference for the criterion
I have a summary sheet that includes the following columns. * Ticket# * Last Name * First Name * Biosketch In the Biosketch column (and two others), I'm using the formula: =COUNTIFS({GH Ticket #}, 1114, {Last Name}, "Meyer", {Bio}, 1) I would prefer to use a reference to the column in the summary sheet instead of typing…
-
Exporting graphs from a dashboard
Is it possible to export a graph from a dashboard? I'd like to be able to use the graph in a PPT presentation but can't find a way to export.
-
User attachments
Hi, My team members are unable to attach files under the Individual Plan. According to the Smartsheet features attached, I should have this feature on my plan. Thanks, Kyle
-
Getting Status of Children to roll up to Parent Row
I have Parent tasks with Children tasks in a dropdown list column. The options for the children are: assigned, in progress, complete. would like to have the parent status display be blank if none of the children have a status selected (all are blank), display "Complete" only if all the children have a complete status,…
