-
Sheet Summary
I have a sheet that I created as a log essentially. What I'm wanting to do is create a "report" that summarizes the data. As an example, I want to report total records, smallest number, largest number, and count of records with a specific condition. How would I go about doing this?
-
Some of my parent rows are grey background, some are not...
Hi, I'm trying to figure out why some of my parent background are grey, and some are not. In the page: https://help.smartsheet.com/articles/504734-hierarchy-indenting-outdenting-rows about 1/2 way down, under "Expanding and collapsing.." both "Administration" and "software engineers" parent rows are grey background. But in…
-
Formula help
I'm trying to create a single sheet that has multiple audits from 4 facilities. I am finding problems in trying to have smartsheet count the amount of cycles in the audit. The information is being input through the web forms so new rows are being created constantly, and the information needs to run through the sort filter…
-
Send Row - Filter Save
I utilize the Send Row feature on a daily basis. The majority of the time, the columns I select from the "Customize" section are the exact same. It would be awesome if I could create a filter and have the ability to select it as opposed to manually selecting all of the columns every time. Thanks
-
Moving a sheet
We are new to smartsheets. We can not move a sheet from Sheets to Workspace. Does anyone know why this is happening. I can move some sheets but not one. I am sure it is how it was created or some setting but I have looked and nothing stands out.
-
One sheet, diffrent collaborators
Dear, We would like to use one sheet/workspace. This sheet with be used by different collaborators with different permissions: 1. On Site; 2. Engineering; 3. Project Management. I would like to make one column with the above mentioned. When i add a task to (for example) onsite. I only want them to see the task for On Site,…
-
Question about tracking project budgets in Smartsheet
Hello all, I'm working on a task where I have multiple project budgets that we want to track in one sheet. I thought the best way to do this would be by using individual sheets and then running a report to include data from each sheet but our Finance department is asking for a way to do multiple jobs (projects) and…
-
HELP - FORMULA - equal to AND IF/THEN
Final Decision (WEBFORM) is a hidden column with the webform results in Yes, No, Hold symbols I need a combination formula for "Final Decision" column: 1. To equal the results in "Final Decision WEBFORM" column 2. AND IF "Final Approval" Column is checked, then show "Yes"
-
Website migration project
Hello, I'm a new Smartsheet user, managing a large health care website redesign project. We have a large amount of content to move from an older CMS to a new one. We're also moving from a static to a dynamic site environment. Are there any users here who have used Smartsheet to manage and track a large content migration…
-
Relationship between the "Status" column and other columns
I'm relatively new to Smartsheet, but it seems strange that the Status column appears not to have any relationship to other columns in the project sheet. But maybe it's possible to use a formula somehow to do that? Some specific questions: * If I change a task from Not Started to In Progress, can I set up Smartsheet to…
