-
Form Confirmation Options
Is there a way under the Form Confirmation Options to show a confirmation message AND include a hyperlink to a Smartsheet? I see the box accepts HTML code, but it doesn't format correctly.
-
COUNTIFS with an OR statement
=COUNTIFS([Phase]:[Phase], OR(2", "3", "4"), [Project Status]:[Project Status], "green") When I input this formula I am getting a message back reading "#UNPARSEABLE". The part that I am struggling with is the OR statement. Is an OR statement possible within Countifs?
-
Workday formula
I want to insert the WORKDAY function into my formula. Where would be the correct location? =IF(ISBLANK([Acutal Start]@row), ([New Estimated End]3 + [\[Duration\]]@row), ([Acutal Start]@row + [\[Duration\]]@row))
-
Blank Rows in Gantt - Automatically get populated by start date
In Gantt format - I leave some rows blank to separate workstreams or buckets of work. But for whatever reason - Smartsheet goes and fills just the start date automatically in these row. I delete them, and then after I save, they come back again. They are harmless, but misleading and hurt the aesthetics of the chart. How…
-
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…
