-
In Form, "Clone" does not appear like in eAcademy video
In the eAcademy video on Forms, in Lesson 4, at -2:12 in the video, Crystal Morey explains that, after clicking "Forms" in the tool bar, and then clicking the "More..." link, that you can then click "Clone." In actuality, "Clone" does not appear. Is there something that wasn't explained that I am not doing, or is Crystal…
-
concatenation
On form B. I added this formula. I'm trying to concatenate all of values in a column named Request ID (in Form a) based on the value Description (in Form B) to the Vendor Number (Form A) =INDEX([{Request ID}]1 + [{Request ID}]999, MATCH(Description$9, {Vendor Number}, 0)) Form A Request ID Vendor Number 123 A 125 B 126 A…
-
Problems with nested IF/COUNTIF statement
Hi, I am trying to summarize in a parent row the information underneath. In the child rows, information is either inputted as N/A, or as a numeric value (%). For example, child rows are as follows: N/A N/A N/A 5% 10% I want the parent row to look at the child rows and determine if they are all N/A, in that case what should…
-
Sharing my pre-defined filters with my colleagues
Hello community, I have a set of pre-defined filters for a smartsheet I own. I would like the people who share this smartsheet to be able to use those pre-defined filters. When I look at the smartsheet on their computer, they cannot use those pre-defined filters. Any clue ? Many thanks.
-
Automatic document archiving?
Hi, we currently use Smartsheet to house our policy and procedure frameworks. One of my colleagues have suggested considering a more capable CMS that can automatically archive old documents. Currently each policy or procedure are attached to an individual Smartsheet row. When the document is superseded we either leave it…
-
Variations of Forms Recently
Hello, We use the form function for all of our production orders everyday and recently, the form has been flip flopping between two different layouts. One is where there is the capability to upload multiple documents at a time and one where you cannot. Is Smartsheet doing some sort of testing or updates? Appreciate any…
-
Contact Column Question
Hi everyone! I have a quick question, so I am currently trying to make a sheet to send out approvals to vendor managers for extensions for expiration dates. The thing is the managers are all part of different departments and not all departments use Smartsheet so not all of the managers even have an account. I have a column…
-
Dependent tasks should not be forced to follow
Hi all, When 2 tasks are created and task2 is made dependent on task1, task2 is automatically moved so it follows directly the end date of task1, and there is no way I found so as to create a time gap between the 2 tasks. My team often wants to work on yet another task, say task3 and have task3 worked in between task task1…
-
Published Links
Do published links expire after a certain amount of time? We are using published links for invoices and have noticed some stop working but cannot confirm if they ever worked at all.
-
Criteria need for a "is one of" filter
When making a filter using the condition "is one of", how do you separate the options in the criteria? I have tried commas, semicolons, quotation marks and parentheses. None are working.