-
Jira Connector Sync - Rows getting rearranged
Everytime I update my plan on smartsheet that uses Jira connector, post the sync with Jira, it re-arranges the rows in a random order (maybe based on order of sync). Why does this happen and how can I lock the rows so that the hierarchy I define on Smartsheet manually never gets re-arranged but only receives updated value…
-
Formula placement where data rows are constantly changing
Hi All, I am trying to build a report or sight that captures the count of various columns based on other columns. {PLEASE add the funciontality of formulas referencing other sheets}. The count and countifs formulas work well in isolation. I can add the formula in a new column and then hide this column. The problem I have…
-
Assembly + Inventory Tracking
I've created a smartsheet to track every unit we sell of one of our particular product lines. The sheet includes the unit's serial number, model number, client name, client PO number, internal 'project number', current location of unit (Ex: "On order", "Johnny's bench", "Software dept.", "Warehouse", "Shipped - En Route",…
-
Scoring
Hello, I am trying to setup a Risk registry where user selects the probability (very high, high, low) and formula in a new column says if High, then score is 0.07. I then want to do the same thing with Impact (user selects impact high, low etc. A new column puts a score based on formula: if high, then 0.05). I then need…
-
Extract a number from the Left of a cell - HELP!
Good Day to ALL. I am new to the vommunity and need some help.... I have a survey form for my clients and when the results are populate, I would like to tally the results - by client. What I am looking to do is extract the number to the left of the survey response. eg. 5 - Very Satisfied 4 - Somewhat satisfied 3 - Neutral…
-
reminder to change oil after 5000 miles with multiple vehicles on the same sheet
I have a spreadsheet for truck maintenance on my vehicle fleet of about 15 vehicles, and I am trying to figure out a formula or some way to send a reminder email if the truck has accumulated 5000 miles since it's last oil change. I have columns for the date, the truck I.D., a checkbox for if the oil was changed that day,…
-
Showing Milestones in Sights
I use a Sight as a dashboard, so I created a report to pick up only entire schedule for each project. i.e. I have 5 "bars" in the report, represents 5 projects. And I want to show milestones with each bar. Can I do it? If so, how? Each bar is cell-linking so I can go each sheet (project) if I click and see milestones. But…
-
Form - fill requestors e-mail address (or name) automatically
I'm creating a request form and want to fill requestor's name (or e-mail address) automatically so that requestor doesn't have to fill out by him/herself. Can we do it? I see "contact list" as column type, but doesn't look this offers what I'm looking for. I looked around Formula/Functions but don't see similar functions.…
-
Dynamic drop down list
Is it possible to link a drop down list to a query from another sheet column. For example It would be great to be able to have users select items from a list of the top ten sold items. This list would update as sale demand changes. or being able to only select items of a certain type based off another column.
-
Can't Remove Dates
I have an old project that may or may not resume. Either way, I want to kind of archive it by removing any dates and moving it out of the way to the bottom of my sheet of projects. I have a few Master Tasks with subtasks. I deleted all the dates on the subs but there are still dates on the masters. I have filters that…