-
Approvals, Updates and Deleting Attachment in a Webform during Update
HI there. I am only a month old Smartsheet user and currently under the Business Plan. i am building the New Hire Request Form for our company and I came across with problem in the multiple approval as well as the things to do before a request will be approved. When the requestor filled up the request form, it will prompt…
-
COUNTIF Formula for when a cell contains a specific word/phrase?
I'm trying to create a formula that allows me to count the number of times the word "Postcard", for example, appears in a list in a column. I am referencing a column in another sheet to do so. However, nothing I've tried works. My instinct was to try =COUNTIF({2018 Open Enrollment Feedback Range 1}, "Postcard"). However,…
-
Software vendor comparison sheet template
Does anyone have a software vendor comparison sheet to share with the Community? Comparing features and functionality of various vendors in one sheet is a challenge. What do you think would be the best sheet template to compare vendors?
-
Unhide Columns (Selective)
Not sure if this was a previous discussion item, but wondering if there is a selective way to unhide certain columns, or is just the all option. Problem being I have large amount hidden and at times just want to revert back and unhide one or two. Thanks in advance, Tom
-
Unable to log in
Can’t log in, keeps saying This site cannot be reached we have the internet & it is working with everything except letting us log onto smartsheet.com
-
Formula from hell
I have ranges of data in multiple forms. There is criteria that must match from each to be summed on a third sheet. The criteria are GL Accounts and a month Code. One of the month codes is listed as 12 Month. The intent of that code is to signify that the cost in one of the columns should be spread across 12 months. So I…
-
Return entire row when value is matched in another sheet
I have a source sheet with hundreds of rows of entries. One of the columns is named Property. There are many different values under this column. I have a destination sheet for each one of these possible values (in this case, a property). What I would like is to have have any rows in the source sheet which match a specific…
-
Critical Path Tasks
Hello, I would like to ask how I can create report for critical tasks ? Regards,
-
return fiscal quarter from auto generated date column
Hi, this formula returns a blank - what is wrong? =IF(OR(MONTH([Created Date]9) = 8, MONTH([Created Date]9) = 9, MONTH([Created Date]9) = 10), "Q1FY " + YEAR([Created Date]9), IF(OR(MONTH([Created Date]9) = 11, MONTH([Created Date]9) = 12, MONTH([Created Date]9) = 1), "Q2FY " + YEAR([Created Date]9), IF(OR(MONTH([Created…
-
Help! COUNTIFS Formula Logic with 2 Date Fields
I am referencing V2.0 of a shared spreadsheet that now has 2 "Created Date" fields: 1) the system generated CREATED column that will be valid for all new entries going forwards, and 2) a LEGACY CREATED DATE column that reflects when older entries were originally created (before they were imported into the new sheet. I have…