-
Sheet permissions
When I share a sheet with anyone from my account with editing permissions, they can edit the sheet on the mobile app but not from a computer. Yes, they also have a Pro account and it also shows the proper permissions on the "share" page. I have used Smartsheet at my last job extensively and know the software quite well but…
-
How do I change when my Sheet starts the next workday?
I have a formula in Sheet Summary that counts workdays remaining until launch. It works except that the count doesn't go down each day until 10 AM. If anyone looks at it before 10 AM, it shows an extra day. I can't figure out why it updates at 10 AM, so I don't know how to fix it. Ideally, it would change at midnight.
-
Clone cells or rows?
Hi All, Hope you are well. We currently use Smartsheets as part of our product management and planning. We have a Sheet with all our current development work some of which has been started and some of which has not been started, the problem is this sheet is getting quite big with all our current and upcoming work its named…
-
Move rows to another sheet Workflow - Select a destination sheet is blank
I have created plenty of sheets that have a workflow to move rows to another sheet. There were no issues to create those automations before until now. I am the owner of all of our Workspaces and sheets but for some reason Select a destination sheet window is blank. I have tried to sign out and in and tested with the…
-
How can my index/match formula include a column that has multiple values
Ok so I downloaded an inventory management template that is awesome! When people submit a request form for a ppe item they need, it has index/match forumlas to show us what Current Inventory remains. Its great! However, they are only able to select one ppe item from the drop down list. And I need them to be able to select…
-
Count Columns in data sheet to appear in calc sheet.
I need help writing a Smartsheet formula that examines the "status" and "County if known" columns in a data spreadsheet. I want it to count the number of each type of status for each county. The Smartsheet containing the data is named "Test of File a complaint" the sheet where the calculation will appear is named…
-
How can my index/match formula include a column that has multiple values
Ok so I downloaded an inventory management template that is awesome! When people submit a request form for a ppe item they need, it has index/match forumlas to show us what Current Inventory remains. Its great! However, they are only able to select one ppe item from the drop down list. And I need them to be able to select…
-
Formula to copy all dates in a year for 120 rows?
Hi all, I need to add a formula to a sheet that will create 120 rows for the same date for all days in 2024. For example, 1/1/24 will have 120 rows, then 1/2/24 will have 120 rows and so on. Is this possible? Thanks! Jackie
-
Is there a way to "cap" the days on a sheet?
I've built a sheet that calculates the days since last event. I display this on a dashboard in chart form. However, I don't want the days to just keep increasing indefinitely. Is there a formula or a way to "cap" the days, for example ">365".
-
Trouble with Checkboxes
Hi there, I've created a sheet and given someone "Editor - Cannot Share" permissions. For some reason, they are not able to check the checkboxes in the sheet. Any ideas what's going on here?
