-
How to delete referenced sheet formula
Within a sheet (call it "A") I used a formula referencing a different sheet (let's call it X). Later I deleted sheet "A". However I see an annoying "Used in formula from unknown sheet" in sheet X. Is there any way I can clear these out? Please help.
-
Reports
My company currently uses Device Magic Forms to do daily reports for people to communicate from the field to the office. We then have to take what's on those forms & re-input that information into Smartsheet to track our projects. This is a time suck on our company, so we are trying to directly have all of this on…
-
Formulas Across/Within Sheets
Building an employee hiring database (sheet 2) off our hired applicants sheet (Sheet 1). After typing an email address in the first column of the sheet 2 , it should populate 4 or 5 subsequent columns across the same row in sheet 2. The column information and email address are both included in sheet 1. I have tried many…
-
Business Days
Someone knows how to include weekends in a single row on one sheet and that all other rows include only work days? Thanks!
-
Nested IF Error - Incorrect Argument
Hi all, Longtime reader, first-time poster...having a struggle day with the brain and some trouble with a nested if shooting back the INCORRECT ARGUMENT error. Trying to code a 5-Part Progress Bar column with ranges based on a Status % column for a Project Tracker. Here is what I have: =IF([Status %]88 = 0, "Empty",…
-
Client Invoicing
Hi, I just signed up to the trial of Smartsheet today, so I'm very new to all of this. I'm wondering if we can use this for client invoicing. As a start, I have set up a sheet that lists employees, which includes a "Client" column to whom their time should be billed. For each employee, I have set up a separate time sheet…
-
Satisfy all requirements; with different formats of columns
Hello :) I need some help :) i think i have a few steps i will need to complete .. however big idea is to be able to make sure multiple columns have criteria matched; then send a notification with an attachment as well as mark a checkbox complete .. initially i think i need to use a countifs formula to tally all columns…
-
Reporting and dashboard help
I have a smartsheet containing work experience for every person in our company. The rows go something like this... * Steve Smith | Project Manager | Company A | 2.5 years | etc... * Steve Smith | Project Manager | Company B | 1.5 years | etc... * Steve Smith | Project Coordinator | Company B | 5 years | etc... * Karen…
-
"No Filter" view
After viewing a filter a user selects "No Filter" to return to the full sheet. Whenever I return to the "No Filter" view, the view is not what it was before I selected a filter. For example, I have a specific section expanded and all others collapsed. I select a filter, then go back to "No Filter" and all of my sections…
-
Adding to dropdown list
I have a dropdown list created, and I have it set to not restrict to the dropdown list only. I would like to know how to easily add values to the dropdown list without having to go into the column properties. Logically I would think if I type in a value in the cell it will add to the dropdown list, but it doesn't work that…