-
Renaming columns affects reports
Why is it that changing the name of a column in a sheet breaks all the reports that include that column? I need to go into each and remove the column with the now defunct name and then add the column back into the report again. This is tedious and frustrating (what if I miss a report?). Fortunately conditional formatting…
-
Where do you record action items in the meeting template set?
We have been using another procedure in the past for our meetings whereby the agenda is at the top and as each topic is discussed, action items and the person assigned to them is on a separate section below. I seem to missing a similar provision with this template set or am I missing something?
-
Form URL Link
Hello everyone. My issue here is that I have created a form and I am not sure how to shard it with other users as there is no URL Link for the form, only available for the spreadsheet. On the Manage Forms, I can only see the button, "Test This Form". Any ideas? Thank you in advance!
-
Sum duration for multiple nested child/children rows.
Why can I not get correct totals on Duration days if the parent has multiple nested children within children? parent -> child -> childOfChild I expect that the sums on durations would total in such order, leaving the parent with the complete duration total from all children, and related sub-children
-
Dashboard Chart
Is there a way on the dashboard charts to drill down to a report? For instance, a bar chart - each bar shows names and the qty of projects they are on. I want to be able to click on each person's bar to a report of their projects. I know you can create an interaction, but that only allows ONE.
-
Changing Email Addresses
Hello, My colleague created an account for me while trying out smartsheet. We've since started a full implementation of smartsheet and I need to pull my old e-mail address over. Problem is that smartsheet is telling me that the e-mail address I want is in use by another account (even though I've deleted the account used in…
-
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?