- Update Request with attachment
I've tried to send an update request to include the files attached to that row. I've selected "include attachments." However, the updated request does not send the attachments along? Is this a bug or am I doing something incorrectly? When I 'send' the row and select attachments, it works fine. Any help on this is greatly…
- Nested IF Statement Formula
Hello Team, This would be a great formula to incorporate into my daily SmartSheets process within my organization. I would like to know how to create a nested IF statement if this is the correct formula to use, that uses an RYG (red, yellow, green) light flag formula to set the status of a task based on its…
- 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…
- 日期是在未来的5天
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…
