Hi there I need a formula that will look across rows and columns in a table.
For example, I need the result for School District-B with 23 items. The result from the table below should populate with: $350
1-5 6-15 16-25 26-50 51-100
I'm seeing behavior in a sheet that I'm not sure if this expected or not.
I am a known contact in our corporate instance of Smartsheet. The screenshot displays content in a sheet column that is created by submission of a form. For this particular column, it's populated from an email address in
I'm creating a training portal with a series of tasks for users to go through. I'd like to grant access to a specific report based on a user successfully completing two initial tasks.
The first tasks are as follows:
1) Open a report to [a] check a box and [b] change a Harvey ball.
When an employee leaves the company, we want to deactivate a User, but retain their data on our sheets (for history reference). If we choose "Remove User Sharing Access", will this simply remove their ability to log into our Smartsheet account?
The Status remains "Active" for this employee. Is
My team is creating a form to collect, track, and act on paid-time-off requests and part of the system we're creating is making a form for folks to submit their requests through.
We need to share parts of the content of this sheet with multiple different parties so plan to create some reports
I am trying to create a procurement Smartsheet for my company, using Google Forms as a method of collecting data for procurement requests. The reason I am using Google Forms is that it has form logic, which is something the people at Smartsheets have not implemented yet, but are working on
I would like to create a formula that measures the health of a project (Red, yellow, green) with missing dates:
Expected Date (June 6, 2019)- I assign that date to the vendor
Scheduled Date (this is expected within 5 days of assigned expected date)- this is filled in by vendor
Completed Date (this
At my company we have a few hundred users. They are all divided up into departmental groups also. Is there an easy way to share a sheet or workspace with all users at once. All I see in the list are all the departmental groups and the individual users. Nothing like an "Everyone" selection or