-
Data mapping for documentation
As we've been increasing our implementation across all of our departments, the need for documentation is growing. I think it would be nice to have a utility that would generate either a graphic map, or spreadsheet; that show all cross-sheet references, automations, cross-cell references, etc. This would help in creating…
-
Merged: Allow Certain Users to Make Edits to Specific Columns
This discussion has been merged.
-
Checkbox Formula Not Working in Metrics Sheet
I am trying to make a metrics sheet that shows how many checked boxes there are in my sheet. The tutorials I found said that "true" and "false" mean whether the box is checked or not. Why are my results showing as 0? I should have at least 20 as checked. I used the formula COUNTIF({checkbox 1}, [Column7]@row) This was…
-
You do not have access to this item
I was given access to Smartsheet this week but when I try to access a sheet in my workspace the message tells me that I do not have access to this item. My Admin has added me to the group for the workspace, as far as I know everyone else in the group has access.
-
Automate Weekly Copy/Paste of Hierarchy
I have a weekly tracking sheet that I update each week by doing the following: 1) Copy/Paste the current week's hierarchy (lines 546-561 in screenshot) to the last row of the sheet, 2) Update the week column, and 3) Clear some of the data for the new week. While this doesn't take a long time for one sheet, I do a similar…
-
Published Sheet Calendar shows as 'Busy'
Mods: Don't merge this with 'Outlook Calendar integration showing time of event and not just the day,'. The only similarity that they have is that they deal with the calendar publishing functionality. When importing a sheet calendar into Outlook an event shows the user as 'Busy' all day and shades the rest of the calendar…
-
Subtract Invoice amount from Total based on Status, in Parent-Child relationship
Hi all, I am new to create sheets, but I am trying to create a solution to track forecasted invoices that need to be sent out. I want to put each invoice total separately and when the status is marked as "Complete" I would like to have it subtracted from the Contract Amount to show the Contract Balance. I set it up so the…
-
Automatic sorting
i have a sheet that has data with dates added from a form. it always adds a new request from the form to the top and i have to manually sort it by date in descending. is there not a way to have it automatically add the data by the date in descending order?
-
Stop autoformat to a percent
Hello, I have a form that collects information on a person's effort on a certain project. The field is left open & not restricted to a certain value as it depend on the person/project what is best to enter. The issue is that Smartsheet takes some of the values & multiples by 100 so that I get 100% to 500% showing often,…
-
How many would be interested in more visual customization in sheets?
A primary use case for Smartsheet for my department currently is what we call Selection and Segmentation. Essentially we crunch a bunch of data about influencers in a particular field and match this data to the goal of a company we consult for. We then suggest a pool of candidates for the company to focus their efforts on…