-
Charting on non-primary fields
I have an Risks, Action Items, Issue, Decision and Questions.. (RAIDQ) sheet. The description is the primary column (field). I have created a few reports using the RAIDQ as the source sheet. I want to create a charts in a dashboards RAIDQ by Priority, RAIDQ by Status, RAIDQ by Category. I am unable to select any other…
-
Want to change our View By in Card View
When I am in Card View I would like to "View by: Assigned to" but the only option is Status. How can I get our Assigned To column when in Sheet View to act as the View By priority?
-
Vlookup
Hello, i have a sheet with billed claims including a column "Pending Amount", and "Detail ID", each line item has a different detail ID, now i want to update the pending amount column according to another sheet, i tried the simple Linking Cell method but it did not imported the pending amounts to the right detail ID's. and…
-
Translating Data from One Sheet to Another
I am looking for any method that could help me obtain the desired results. I have a tracking sheet titled “PM Sales Tracking” and within the tracking sheet there is a column that is called “Design Request” I have edited the column properties(design request) to a “dropdown list” with values of “yes and no” depending on the…
-
Drop down list dependent on the data from other column
Hi. Is it possible to create a dorpdown list that is dependent on the option selected in other column. For example, when I select "Audit Department" in column A, the list of audit tasks will only appear in the dropdown list in column B and when I select "Tax Department" in column A, only the Tax related task will appear in…
-
Keeping persistent dates for status changes
Building a kanban board with typical IT cycle states: Ready, Dev, Test, Deploy, Done. I'd like to track cycle times and throughput. I've created (locked) columns to capture a status change for each of the cycle states; e.g. Dev Start and formula "=IF(Status@row = "Dev", TODAY())". That works to capture the date that a task…
-
Nested IF(ISBLANK & Date Columns w/Progress Bar
Hi Everyone! I would like to know if you are able to use date columns when automating a progress bar. Basically dates are entered as product moves to a new stage in the process. As the dates fill in, the progress bar fills as well. I've used nested IF formulas for automating a progress bar but, for whatever reason... Im…
-
Scanning a Barcode
Does anyone currently know if smartsheet is capable of capturing data from a bar code?
-
Smartsheet with series of dates representing milestones acheived
i have Smartsheet with series of dates representing milestones acheived. Users enter dates as when they have completed each milestone, How do i measure days between these dates and then put into a dash board /charts depicting what the average days between each point is at each milestone. eg Date of request1 - date of…
-
Approvals, Updates and Deleting Attachment in a Webform during Update
HI there. I am only a month old Smartsheet user and currently under the Business Plan. i am building the New Hire Request Form for our company and I came across with problem in the multiple approval as well as the things to do before a request will be approved. When the requestor filled up the request form, it will prompt…