-
Average duration formula
I'm trying to get a formula for a sheet summary value to calculate average duration of rows where Risk Type = "EDAM Risk" and Status = "Resolved - Mitigated" or "Resolved - Decision." Assuming: Duration is in a column named Duration Risk Type is in a column named Type Status is in a column named Status I've been using the…
-
“File Creation Restriction”
Hello There , before smartsheet switched to the new license type, the users to whom I gave editing permissions could not share the page unless I granted them permission. In addition, users did not have the ability to create pages. This way, as the admin, I was aware of all the pages created in the company and could…
-
Access to add data to sheets
we have a lot of sheets that users need to enter data and add attachments and the like. what permissions are needed for this? it seems we have some users who are admin - but they don't really need to be. so how are the permissions set to be able to add data to sheets, and remove from being admins?
-
Stopwatch Style Time Tracker
I believe the community has been looking for a solution for years. I have successfully created a way to have Stopwatch Style Time Tracking – On any sheet, at the parent or child row, by individual, and allowing manual edits! This is without using Resource Management. I used Bridge to handle the automation and two sheets…
-
Edit Smartsheet or Excel Template (can't locate)
I started using this smart sheet for study planning. I work FT and have a demanding study schedule. I needed to add time to the sheet (15 min. intervals would be preferred) but I can't figure out how to adjust it. I also can't locate this template anymore. Uploading for reference. A tally at the end (sum) for total hours…
-
Table View - No Reminder Option
Smartsheet Grid has the reminder option. Smartsheet Table (New) it does not has it or at least not in the same area as Grid, does anyone know why, or how do I get it while in the Table view?
-
construction cost estimate for installations
Can someone help me and give me an idea on how to create a cost estimate for installations, with a total for each chapter by groups, subgroups and types of work, but at the bottom of each chapter. https://us.v-cdn.net/6031209/uploads/0OSH46KSC2LH/cost-estimate.xlsx Thanks
-
Freeze columns - do not stay in place in Grid View
When freezing a column, things stay put usually, but the frozen columns retract / collapse upon saving or moving the app / browser from one monitor to the other. When this happens, the user needs to stretch the frozen column to back to its original orientation.
-
Need the hyperlink column to be included in the Smartsheet API response.
Need Smartsheet technical expert suggestion or approach to retrieve hyperlink from Smartsheet API The recommended approach to retrieve hyperlink data structure from columns via the API Any specific column type configurations or API parameters that might be required Best practices for handling hyperlink data in API…
-
Why isn't my sheet pulling into a report?
I created a new sheet for my team by replicating an older sheet and now my tasks aren't pulling into my task report or any of my teammates. I confirmed the sheet was selected in my report but it still isn't pulling in. I've never had an issue with this before so would love some advice on troubleshooting.