I'm trying to sum monetary amounts for a certain customer while referencing the data from a separate sheet. However, I only want to sum those amounts that fall within the FY20 (fiscal year) dates of 4/1/19 to 3/31/19.
Here's the start of my formula that sums all dates, but what conditional formula
Ok. After 1.5 hours of trying to figure this out myself, I am reaching out to the experts.
I have multiple Smartsheet Forms feeding into one Master Data Sheet. Each row of incoming data is then assessed for approval based on certain cell criteria, and if approved I check a box in the "Approval"
Is it possible to sum the counts of specific cells on different rows in the same sheet.All the cells are in the same column.
Hi SmartSheet Community,
I'm looking to use conditional logic in forms. Can someone update me as to it's availability? Has it been implemented yet?
I've read this discussion and posted my question there but got no response:
I am trying to create a Web Form with 2 options and would like different fill-in fields depending on the option selected. For example, if a user selects Product Development, they should be asked to fill in fields for Project ID, Aproval Date etc, but if they select Production Support, they should be