-
Is there a way to crate a custom sort order on reports?
I have a report that includes a "Priority" column (single select - Critical, High, Medium, or Low). When I use the sorting function in the sheet, I think it sorts in the order of the list that I typed in the column properties. However, when you're in a report, the sorting only allows for ascending or descendingโฆ
-
Multiple workflows in a worksheet - "This workflow was triggered by at least 5 other workflows"
Hello all, I'm currently having a sheet with the answers from one survey form (30 questions). The answers are YES/NO option, but then I would need to convert the YES and NO in 1 and 0. What I did (and maybe I overcomplicated myself) was to create 1 workflow per column. When a new row is created then this triggers the 1stโฆ
-
Cut and Paste Rows doesn't insert new rows above my existing rows
As I'm planning my project I'm moving rows around quite a bit. It seems like a simple thing and there should be a way to cut a group of rows (sometimes parent/children rows) and paste them above other existing rows. However, when I do that, it overwrites the rows below it. I have to count the number of rows and insert if Iโฆ
-
Identifying Duplicate Values through Conditional Formatting
Smartsheet Community Members - I'm using Smartsheet (Forms) to manage system access requests. Users provide their Username and to which System(s) they need access. I'm trying to employ conditional formatting so I can easily identify which requests are duplicative based on whether a request already exists for the sameโฆ
-
Dynamic Production Date Schedule
I work for a small company who manufactures kitchens in Oxfordshire. We are able to make 9 kitchen units per day, 4 days a week - so a kitchen that has a total of 27 units would take 3 days to complete. As there are many external factors that can delay or bring forward the manufacturing dates, there are many occasionsโฆ
-
JIRA Sync To Smartsheets Not Syncing
The Problem: JIRA is actually not auto syncing like it should to pull in tickets automatically into smartsheets Notice: The workflow is set correctly to sync JIRA fields to smartsheets The Problem: We have to go into this workflow manually, edit it, then let it run every day. This is NOT automatic syncing like its intendedโฆ
-
Birthday/Anniversary Reminders
Hi, Please can you help. I'm trying to set up a sheet with birthday/anniversary alerts and messages. I found a few questions and answers regarding this, but none of those formulas are working for me, I keep on getting errors, so I am probably doing something wrong, but I just can't figure it out what I'm doing wrong.โฆ
-
Contact in my organization dont show
I have a form that whenever i try to write down the email that should receive the notification. the email doesn show up. i tried couple of people in my organization, and nothing show up too is there an issue ? or they have to have account in order for their email to show
-
Do we have report filters that can filter something like "Last-Week" Workdays only?
I need a filter to filter performed task in a weekly basis without inputting the dates. Currently I use the filter "between ddmmyy and ddmmyy to create the reports. This is time consuming because I have to reset the dates manually weekly and with a lot of projects, it is gradually becoming unsustainable. Now, I can see "inโฆ
-
adding in already submit form ( the receiver)
is there a way for the receiver to add a value on already submit form. Im working on full maintenance request form for the rig operation. we have a requirement that state only do full maintenance whenever it reach 5 or 6 jobs. the issue is the operation team do not know the number of the rig completed, so i need theโฆ