-
Locking Dynamic View after a specific date
Hi, Does Dynamic View offer the capability to lock the view after a specific date? I need users to make some data entries up until a specific date after which they should not be able to make or change any entries. However, they should be able to see their data. Will locking the rows in the original sheet prevent users from…
-
Update Request Links
Hi - I'm wondering if there's any way to capture the actual Update Request link (what comes through in the email when you send the Update Request) in a report? Our account people get tons of Update Requests, and don't always have the info to follow up immediately. So, rather than have to sift through emails, is there an…
-
Trying to combine 2 AND functions with an OR
Hi There! I am new to SmartSheets and am working on a way to automate a process using the OR with AND's and running into trouble. Basically, I am trying to check a box in a column if any of the following is true. If the Model type is 1 AND the version is less than 9 OR If the model is 2 AND the version is less that 18…
-
Is it possible to hide dates in a project plan and display week 1, week 2, etc.?
I'm setting up a project where the start date is still to be determined. I have been asked to provide a column that has the week a certain activity needs to occur in. For example, instead of kicking off the project on 25/09/2023 the Grid View of the project plan should have a column in it that shows the project kicking off…
-
Can smartsheet create and display Binomial Trees?
Hi, I was wondering if anyone has tried to create and display a Binomial tree within Smartsheet? Is it possible, as I have been unable to find a template for it. I don't need it to run the calculations more for display purposes only. Thanks.
-
Combined Multiple IF CONTAINS Functions
Hi, I have the following formula =IF(CONTAINS([Column A]@row, {Sheet A Range 1}), "Sheet A", IF(CONTAINS([Column A]@row, {Sheet B Range 1}), "Sheet B") Now I want to add if both sheets contain [Column A]@row, result: "Sheets A and B", How do I add this last part in addition to my current formula? Any help is appreciated,…
-
Enhance Auto-Populate Feature for Drop-Down Lists
For long drop-down lists, it is nice to be able to start typing a value in a cell and use the auto-populate feature to reduce the options from which to select. Currently, the auto-populate feature only works if the user starts to enter the value exactly as it appears on the list. Instead, please enhance this feature such…
-
How to set up an email reminder 7 days after creation date
Greetings, I'm trying to set up an automation to send an email 7 days after creation date but I'm having problems. I tried using the function =IF([Creation Date]@row) > TODAY(+7), 1, 0) but it isn't working as expected. When I change the date with a test date from a date column, it works fine. Any ideas what I am doing…
-
Automated Sort in Sheet
Is it possible to create an automation that sorts the rows automatically when changes are saved? For example, if my sheet is sorted by Column "Stage" Numerically Increasing, and I insert a row, fill it in, and save it, I want the sheet to re-sort to incorporate that added row in its proper location. Thank you!
-
Any idea on what Understanding and Hand on experience in Tabular user interface means
The phrase is showing up in job descriptions. Thank you
