AlisonEmployee

Thanks, Paul, this works great!!

正确的,它将有一个的行数,filling over 200 rows with Groups A-C, etc.. This is dummy data to be able to post in a public forum.

The only way to do this would likely be with Forms (meaning, you can require all fields to be filled in before submission on a Form), but there isn't the feature of Logic in Forms, so answering column A would not be able to force you to answer column B. However, feel free to put in a Product Enhancement Request under…

Hi Andrée, I'm working with the user above and what we were hoping to find was a formula to check a box if the user assigned was duplicated. For example, the second instance of my name should check the box, etc.

Hi JB, Thanks for this comment; you're right that it's not available, but feel free to submit a Product Enhancement Request here. In the meantime, you could check out the options that David mentioned, or you could consider using Automated Update Requests to request further information once a form is submitted based on…

Hi there, You can use the currency formatter to indicate each cell's currency, as Andrée was mentioning. The default currency will likely not show an indicator. By this, I mean that, for example, my account is in English (U.S.), so by default, my currency settings are USD. If I format a cell/column/row in USD, it will…

Hm, strange. I'd say that you'd likely want to reach out to our Support team (smartsheet.com/gethelp) to see if they can help you out with this. Sorry I wasn't able to get you a solution right away!

Hi Connor, Is this "Assigned to" column a dropdown list? It looks like it may be in the source sheet. If so, a Report will sort based on the order of your dropdown list, so I'd recommend making sure that it is a Contact List column by going to the source sheet > right-click on the column header > "Edit Column Properties"…

Hi Connor, Firstly, if you're having trouble with the "Assigned To" field in the Report, you may want to ensure that you have each column with the same column type and exact same name (no differences in spacing, capitalization, etc.) in each sheet. Secondly, have you tried using the sort option in a Report to view the…

Hi there, Another option would be to use it as a Widget on a Dashboard, where it essentially does the same thing as publishing (in that you do not need to share the underlying sheets) but you do not need to publish the item. Here's some information on that. I hope this helps! Alison