-
Smartsheet Merge and cell images
I have a sheet that contains a column where I've inserted images. Is it possible to have those images show up when I merge into google docs? I tried but it errored. Do the images have to be a certain size or file type? Thank you
-
If criteria is xxx, duration is zero
Dear Smartsheet community, I have a sheet for staff to report time off. I have this formula to calculate the net working day(s) between begin date and end date. =NETWORKDAY([Begin Date]@row, [End Date]@row) However there will be occasion when staff will not be taken time off. Therefore, I want to add where column Absence…
-
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.