-
Allowing View / Access Of Certain Data To Other Users
Hi, I'm currently creating a sheet with numerous tasks that will be 'Assigned To' other Users. I would like to have the other users only see and edit their tasks, and not have any access to the other Users' tasks. Is this possible? Thank you, Lloyd
-
Fiscal month issue
I cannot figure out for the life of me how to write a formula that would populate "Fiscal Month Due Payment" based on the data on "Payment Date", the first three columns are the fiscal months information, the highlighted area are the results where I'd like to get a formula to do it for me.
-
Visual indicator for row of selected field
A visual indicator that identifies the entire row of the field that has the focus would be fantastic. So when I am typing in a field, I can more easily scan the entire row to make sure I am in the correct row. Basically, the same functionality that the mouse pointer has but for the currently selected field. Of course, the…
-
Cross sheet links automatically update with new rows
I'm working on developing master sheets for my group that other researchers will link to. They will use this information to inform capacity and resources. How do I ensure that if I've added a row to the master sheets that it automatically updates their sheets?
-
Searching Multiple Pages in a Report
Hi, Not sure if anyone is sharing the same frustration as myself with some of the limitations of SmartSheet, but I hit the 25,000 references limit within a month of using the system, and was told to use a report instead by support. This sort of works okay, but then today, one of the team highlighted that as soon as you hit…
-
Publish Links - Access control
I am the admin for my smartsheet, trying to make the sheet public with availability to anyone. The access control button is grayed out. What do i need to do to get this changed? thanks Marian
-
Notifications not including attachments or comments
I set up a notification alert to send an update once a column is checked as "done", and was to include all items in that row, including attachments and comments. However, I am not receiving the comments and attachments. Please help.
-
Report Design - How to show higher level task with late sub-tasks?
I am working on a couple of reports and they are working fine except I cannot see within the report the higher level task which has a sub task that is late. For example: Task Sub Task - OK Sub Task - Late Sub Task - Future. When I get the report to identify the late sub-task, I'd like to be able to see within the report…
-
Calculating business (working days) in a Leave Application
I need to know the number of working days ie Monday to Friday for each Leave Application requested by workers. What is the best way to do this as most forms have the Start Date and the Return Date which includes weekends so therefore any formulas to calculate the number of days will not reflect actual work days.
-
SumIfs Formula is not working out.. Trade1:Trade5, "Demo", Cost1:Cost5
I am really struggling with the following formula.. Below is the list of my columns of data that comes in automated into a sheet, by way of a webform I have about 50 trades, like (demo, framing, electrical, plumbing etc).....I want my formula to reference the trade column, and pick up only the entries for "framing" to date…
