-
Hyperlinks
Hello all, I need help i have a sheet that every week i add about 300-700 lines and each one of them have a Different link, is there a faster or easy way to add them all together? and not each line at a time ? I don't mind adding them all as "LINK" but for now as i am adding them one at a time i am adding Them to the…
-
Automate Update request gives access to view entire sheet
Is there a way of using automation for update request without giving the assigned person view access to the entire sheet? I don't want to do manual requests on each row. Also if they are not a viewer the automation fails. The email that goes out has 'go to the sheet' on the bottom which allows them to view the whole sheet…
-
pivots and access permissions
does anyone have experience and solution for a failure of the pivots app to create ''accessible'' destination sheets in workspaces that I own? The pivot creates the sheets, but will not run, and informs I have no permission to access the sheet. pivots and sheets previously created are still working OK, updating hourly.
-
Rotating Assignee on weekly basis
I’m building a Smartsheet to rotate 30 assignees on a weekly schedule, with each task spanning one week. The formula I created is returning a ‘#UNPARSEABLE’ error. Could anybody advise on how to correct it or recommend an alternative formula that supports this rotation? Any visuals appreciated as well.
-
Merged: Make Cell Usage and Formula Usage Counts Visible
This discussion has been merged.
-
Formula Entry Formatting
I'd like to suggest an enhancement for the formula bar in Smartsheet. As it stands, users are unable to expand the formula bar or input/format multi-line formulas directly. This limitation is particularly challenging when dealing with complex formulas, where keeping track of parenthesis pairings and overall structure is…
-
Sheet Vs Workstream permissions to external users
Hello, My non-profit has some auditors in the office today and they are reviewing some of our project plans as part of the financial audit. To be most efficient I have been asked to give them access to a particular project sheet. However I can't see to be able to share an individual sheet (the 'share' button is greyed…
-
Merged: Dynamic View - add sheet attachments
This discussion has been merged.
-
How do I stop rounding?
Hello! I'm trying to enter tax information for different counties. I need this amount to be 2.0145%, but it keeps rounding to 2.015%. I've added two extra decimal places, and it still rounds to the thousandths place. How can I get the full number to show?
-
Allow display of destination sheet full name in the Edit Automation dialog when moving copying rows
This is a simple request to allow visibility to see or display the full name of the destination sheet in an existing automation. Here is the use case: 1) I have created an automation whose action is to move or copy a row. 2) The name of a destination sheet that is selected is longer than what displays in the Edit…