-
Locking Sort?
Hi Folks, I have a project sheet shared amongst my team where various "editors" are constantly updating statuses, priorities, etc. I have a sort set to first show project status, then priority, but am finding that all of my "editors" can update the sort at any point. It's throwing all the data out of wack. Anything I can…
-
Webhooks vs Built-In Automation
I know that automated workflows in smartsheet won't take place if the trigger is a change on a cell link. Will the same happen in the case of when a webhook is triggered? Will a webhook send if the trigger is a cell linked column?
-
Can you automate attachment exporting?
We can export sheet data automatically using tools like Power Query but is there a way to get attachments out of smartsheet and into our server? Or is this something that needs to be done by hand? Thanks
-
Index and match doesn't always work
Hi, I was wondering if anyone had come across a technical issue with index and match or if it's something I am doing wrong (the formula is definitely correct). I have a critically important index and match on a large number of sheets but it has stopped working. Replacing it with vlookups work so I have a fix but I'd rather…
-
Sheets exiting folders overnight
Hi all! Wondering if anyone else has this problem. I have all of my sheets organized nicely in folders. Many of the sheets are shared (but not at the folder-level). Some days, I log on in the morning and everything is as I left it: Some days, I log in and some of my sheets have decided to sneak out of their folders into my…
-
Is there an option for 'no logo' on a workspace? I don't want any logo to appear on the user forms.
I'm the SysAdmin for our company. We have our Smartsheet 'branding' options set to our company logo. We make exceptions for certain project workspaces so the specific project logo shows up on any related forms. We have a project situation where we only want the FORM TITLE to display and not show any logo at the top of the…
-
Row Limits
We are currently using Smartsheet to record the responses from our employees in a simple daily COVID symptom tracker form. We are currently exploring options to the sheet row limit and was wondering if anyone in the Smartsheet Community had any ideas or other possible solutions.
-
Formula to not Count Checkbox
I am working on building a SUMIFS formula to not count a certain row if a certain checkbox is checked in another sheet. I already have it counting everything if the criteria is correct, but having trouble adding the "NOT" if the checkbox is checked. Thanks, Kris
-
Contracts, Purchase Orders, or Change Order Management
Is anyone using Smartsheet to handle contracts, purchase orders, or change orders? I'd love to see how you manage them with Smartsheet.
-
Multiple IFs then SUM
I have developed individual project sheets. In the project sheet I have multiple tasks. I want to populate number of hours I worked on each task, by summing the number of hours I worked on that project prior to a certain date. I keep all my hours worked on various projects in a work log which I am referencing from the…
