-
Linked Sheets/Copied Rows
I created an automation that copies a row from one sheet to another based on certain conditions. What I am curious about is if there is a way to have information flow back to the originating sheet if changes are made in the 'linked to' sheet. Currently, I can only get the row information to flow one way and I'd like it to…
-
Sheet Help
Hello everyone, I am not sure if this is possible but I am trying to manage a project that involves multiple color approvals for a singular item but lots of different items within the project. Can someone take a look at the attachment and tell me if something like this is possible? I understand the basics of the…
-
Default Sort setting
Hi, How can I set a default for sorting in a sheet? For example, I have a system "Modified Date" column, and I want the sheet to ALWAYS sort by descending order, i.e. the most recently modified on top. I want the sort setting to stay even when refreshed, and when I'm editing in the sheet that the modified row will…
-
Freezing top row OR colour the header row
Am I able to freeze row 1 on a sheet so when people fill out the form, the data imports underneath row one? OR Can I change the colours of the header row like I have with row 1?
-
The ability to omit blank fields in email notifications
When sending alerts and requests through automation, we currently have the option to send a message including either all fields, specific fields or the message only. For my particular organisation(and i would imagine many others), none of these options work. We have dynamic forms that build themselves based on answers and…
-
Do not add 10 blank rows at the bottom of the sheet
Please STOP adding blank rows to the bottom of the sheet. They are unnecessary and can cause issues with formulas.
-
How to get report to show up in sheets folder?
Hello all, I have a Smartsheet report that I can access from the home area or if I click the link directly. However, when I go to sheets, it is not showing up. In the second image, you can see there are no reports, only sheets. Is there a reason that the report is not showing up in the sheets folder? Does it take a few…
-
Data mapping for documentation
As we've been increasing our implementation across all of our departments, the need for documentation is growing. I think it would be nice to have a utility that would generate either a graphic map, or spreadsheet; that show all cross-sheet references, automations, cross-cell references, etc. This would help in creating…
-
Merged: Allow Certain Users to Make Edits to Specific Columns
This discussion has been merged.
-
Checkbox Formula Not Working in Metrics Sheet
I am trying to make a metrics sheet that shows how many checked boxes there are in my sheet. The tutorials I found said that "true" and "false" mean whether the box is checked or not. Why are my results showing as 0? I should have at least 20 as checked. I used the formula COUNTIF({checkbox 1}, [Column7]@row) This was…