-
Do you need to be shared to the folder that contains the SharePoint file for data shuttle to work?
I am trying to get data shuttle to connect to an excel file that was shared to me. However, it appears that I need to be shared to the folder that contains that file as well. When I go into data shuttle and look for the source file, it shows me all the folders that I am shared to and I can see all the files within those…
-
Index Match on same sheet only matches to the first key found at top of row
The Index Match on same sheet only matches to the first key found at top of row where I am expecting it to look at all rows in the sheet. Here's the formula in Col3. =INDEX([Capacity 1]@row, MATCH([Collapsing 1]@row, Key:Key, 0)) And the example is below: You can see that the ABC12345 under Collapsing 1 col matches to the…
-
Conversations Panel to have option "Mark as Unread"
I found the little red dot on the conversation panel is beneficial, when there is a new comment being submitted. However, having an option to Mark as Unread so I / others can go back to that conversations later, would be really useful, so we wont forget. Currently when clicking on the conversations icon, the red dot will…
-
Count Number of Days Past Due
Ultimate goal: Create a formula that will count the number of days an item is past due, while giving credit (by counting it as zero) for items completed early or on time all while ignoring where a due date may have an "N/A" or other issue in the field. This formula will then be used to create an average day past due…
-
Dashboard not showing report totals in chart widget?
Hello I have a simple report pulling data from a sheet. Basic project status (scoping, inflight, blocked etc) that report has a total at the top. When i create a chart in my dashboard it shows all the totals of each status but not the total of all the projects. Total projects for our team. Dashboard shows each project line…
-
Automation randomly causing an Infinite Loop error
I am in need of some help with this automation. It stops running intermittently because of an infinite loop. Any help is appreciated.
-
cc an automation email
I have automation set up to send notifications to people listed in sheet columns. I want to cc the notification email to myself. I do not see an option to add cc. How can this be achieved?
-
Flagging double booked dates and rooms
Hello I am trying to get a formula that will crosscheck the camp / rooms and flag if they double book rooms in the same camp on the same days? If that can be done can I set it to reply back to the customer who books via the form? Thanks for any assistance, I am very new to smartsheets
-
Outlook Add-In: Uncheck All on attachments
When using the add-in to send from Outlook to Smartsheet, if you don't want to attach and item, you have to uncheck each item. I would like a way to "Uncheck All" so that I don't have to click each item. This has become more problematic with users signatures. If they have links to their social media, sites, logos, etc...…
-
Less round and less cartooney fonts and icons would be easier to rapidly scan and ingest
I see the aesthetics of the new, rounder and softer-edge fonts and icons in the menus, but from a user access and efficiency standpoint, do not like them. I want to be able to scan the sheets in my workspace quickly, and rapidly jump between sheets, and these new fonts and design elements are harder to read at a glance.…
