-
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…
-
Hiding or deleting content via Automations
I have multiple sheets following a complex workflow. When some of my workflows are completed and moved to the next step in the process, I want the row of information on a sheet to be automatically hidden or deleted. I see that we have delete a column, but not a row. I need my row to be cleared after the data has already…
-
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…
-
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…
-
New Templates?
Hi Smartsheets Crew; I wanted to know if you guys are going to create any NEW Templates in your Solution Area OR 🤔 If you plan on ENHANCING / ADDING to your EXISTING ones (to utilize any/all recent changes to the software) since the Template(s) was launched? 😁 It would be great to see some fresh new ideas that relate to…