Discussion List
If statement referencing another sheet returns invalid operation
So I am using this: =IF({Master Bookings Sheet-V2.0 Range 1} = [Cutting Room Number]@row, "Unavailable", "Available") Above is the sheet where I'm checking the value of "Cutting Room Number" from another sheet called "Master Bookings Sheet V2.0". I have to check: if the value in "Cutting Room Number" in the above sheet is…
Work APps - Ticketing
For the ticketing, can it be set that: Once a technician is assigned a ticket they would be the only one able to edit it If the technician requests additional information, the user can respond on a form that would populate the same row that has already been generated
Change cell automation not working
I have an automation to change the value of one cell based on the value in another cell in the same sheet. The change is to occur when triggered. The source cell value is based on a VLOOKUP formula referencing another sheet. The cell with the VLOOKUP value changes based on the formula, but the automation to trigger a…
Increase summary field limit (>300)
Hi, I'm running into another Smartsheet limit. This time on the number of fields in a sheet summary. I have about 150 fields so far and I will need more than 300, most likely. But I get this warning: Can this maximum number be increased?
HELP!! Many of my sheets systematically updated to show a "Last Update" date of 8/29/23
All of my oldest (not touched/updated in a long time) sheets in all Workspaces, all of a sudden show a "Last Update" date of 8/29/23. It's as though some backend process ran to update everything that hadn't been touched in a while. There is NO way all these sheets were updated on the same day, most haven't been updated in…
Please remove arbitrary limits...
Here is my Smartsheet frustration of the day. Yet another capricious limit: Why do these limits exist? Can there just be a confirmation box rather than a barrier? Thank you.
Embedding a linked file on a row as a link in a column
Hi all. I was wondering if any of you have found a way to actually automatize the creation of a link based on a file linked to a row. It is probably not even needed to create a link, but to use an IF statement that checks whether the row has some attachment or not (if we can show in a report that there is an attachment…
How do you SKIP a BLANK cell when using an INDEX / MATCH formula?
This is a working formula to pull values from another sheet. The issue is that on the SOURCE sheet, when the "PCN" is blank, they are showing a default text under the "Enrollment - PCN" column. That works perfectly for the SOURCE sheet, but is messing the automations on MY (destination) sheet. =IFERROR(INDEX({Projected…
How can I change the Last name of an unlicensed user
How can I change the Last name of an unlicensed user.
How to indicate there was an update via Dynamic View.
I need to be able to identify when sheet content changes when using a Dynamic View. I see where this can be done via form logic on a new entry, but not when entries are updated. Thanks,