-
Smartsheet thinks we are still on the free version... is there anything we can do?
Hello! Our company recently completed a 30 day free trial of Smartsheet and decided to purchase a few business tier licenses. In our account settings, it shows that we have the business tier with multiple licenses. However, every time I click on a sheet, I get a message that reads "Your sheet is read-only until you upgrade…
-
Sharing & Permissions within Workspaces
I have a Workspace created that houses a number of different dashboards, sheets and reports. If I share the entire workspace with a group of people, is it possible to go in and remove them from select dashboards/reports? Most users will have access to all assets but there are certain pieces we'd like to restrict access on.…
-
Return all unique values by Location
I am hoping that this is possible: I would like to look at Sheet "BIA All Data" and return all "Process Names" that match the "Site Name". For Test Site, there are Process 1 & Process 2 in the BIA Process Name field. =INDEX(COLLECT({BIA Process Name}, {BIA Site Name}, [Site Name]@row), 1) I would prefer that I could insert…
-
Formula to uncheck a box
Hi all, I have a project sheet that I need some help with a formula. The sheet has a checkbox called To-Do and a % Complete. All tasks start with the To-Do check box as unchecked. If the user needs the SME to act on that task, they check the To-Do box. I then have a report sent to each SME with their "To-Do" list. The SME…
-
Automation messages
Hello Everyone, Is there a way to change the sender or reply line in automated notifications sent to people in emails? I am the owner of a lot of sheets, whenever someone sets an automation on those sheets, the replies come to my inbox. Is there a way to direct those replies to a different inbox? I am aware, we can add a…
-
Open in New Tab
Is there a way to configure your personal settings to always open new items in a new tab?
-
Number of days open
Can anyone tell me why im getting an incorrect argument set error with the formula below? Im trying to determine how many days a case has remained open since it has been assigned, but want to ensure i dont include those that have a disposition date entered =IF(AND(ISDATE([Date Assigned]@row,ISBLANK([Disposition…
-
Years of Service with Company - Date Formula - Help needed
Using this formula to calculate the Years of Service, but the formula is rounding up. For instance, 7/18/22 is returning 2 years of service when it wont be 2 years until 7/18/24 =YEAR(TODAY()) - YEAR([Hire Date]@row)
-
Report not showing summaries on Dashboard
I am trying to show results from a report I created breaking down IT costs between software and hardware on a SS Dashboard but when I pull the report over it is only giving me the sums for the parent column (division) and not breaking them into 2 pieces for each dept (showing totals for hardware and software for each…
-
Count how many time the same value appears in a row without defining value in the function
I am building a sheet where we log car registration number / car number plate. Let's say there are 3 column for Date, Time and Rego number. I want to make another column that shows how many time the same Rego number has been logged in the sheet without defining the value of what the function is looking for but rather just…