-
Remotely fill in a new row on another sheet.
Hello, I have two separate sheets that need to be connected. One is an inventory sheet of all raw materials in stock, and the other is a record of all raw materials delivered. If we receive a delivery of a type of raw material we already have some in stock of, the quantity of that material is simply updated in the…
-
Convert Google Doc hyperlink in a cell to an attachment
We have some sheets containing very large numbers of hyperlinks to Google Documents. The links are in a single column, with one hyperlink in each row. This procedure has been followed for several years, rather than using the attachments facility, for internal security reasons which no longer apply. Our organisation is now…
-
Check Multiple Boxes or Tag Multiple Items Within One Cell?
I know I've asked this in the past like 3 years ago but don't know if there mght have been a feature update or workaround for this yet. Is there a way to check multiple boxes or tag multiple items within a single cell? If I made a dropdown menu of 12 items for example, is there a way to check or select 2 of them for one…
-
Keyboard Shortcuts
Oh COME ON! Why why would you change a keyboard shortcut? Are you aware of muscle memory? This just sadistic. Isn't this one of the golden rules of hot-keys? They don't need to "make sense" and you shouldn't need to or ever really be able to guess them. WHAT COULD POSSIBLY BE THE REASON TO CHANGE THEM? My situation: I use…
-
Locking Cell - with Conditions
Is there any way to lock/restrict a cell that asks users to choose a date? For example, I want users to be able to choose a date earlier than what is "listed" in the cell but be unable to choose a date after the date that is listed. If the cell reads 9/1/2019, the user should be able to change the date to 8/30/19 but NOT…
-
Formula to change text
Hello, How do you generate a formula to change the text within a cell. I want to have different text for different due dates such as if the due date is within 5 days, I want the "status" cell to say immediate, and if it is within 2 months, I want the status cell to say "short term", if it is within 4 months, I want the…
-
Approval workflow
Hi Guys, Im new to smartsheet , please help me. I created an approval workflow then if the approver is not around how I am going to reassign it to other approver without breaking the approval sequence. Please let me know your thoughts. Thank you very much.
-
Filters for Smartsheet Documents
Hi all, I am looking to add filters for Smartsheet documents. I am relatively new with Smartsheet and have been tasked with creating some documents and reports. We are attempting to model one of our documents after the picture attached (the first one). Here is a synopsis of several goals we are working on: 1.) One of our…
-
Help! Already reached Vlookups Max reference Cell count of 25,000
I need a solution to the vlookup max reference cell count of 25,000. I have a database that zapier loads data too from an application. The database consists of 134 columns, and will grow to an estimated 300+ row count. Which works out to 39900 cells, which is 14,900 cells over the limit. I use a summary sheet to gather…
-
RGYB Automation
I'm having issues with the following formula and I'm not sure why. Task Formula below: =IF(ISBLANK([Start Date]@row), "Blue", IF([Start Date]@row >= TODAY(), "Blue", IF(AND([At Risk]@row = 1, [End Date]@row <= TODAY()), "Red", IF(AND([End Date]@row <= TODAY(3), [% Complete]@row < 0.75), "Yellow", IF(AND([Start Date]@row <=…