-
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.ā¦
-
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ā¦
-
Sharing Sheets to Multiple Workspaces
I was wondering if I could have a sheet be located in multiple workspaces simultaneously. For example If I wanted to have individual workspaces for each project I am working on, but also have separate workspaces that would allow me to see overviews for ALL projects, all pulling from the same sheets.
-
Form function for SmartSheet
Hi, I have smartsheet to record each building general meeting info, such as building manager, meeting date, building name. In each meeting, we need to prepare meeting supplies (there are around 30 items, such as pen, projector, binder..). I would like to use smartsheet "Form function". Then link is created and I can sendā¦