-
Can you return a blank cell in a formula that isn't text?
Is it possible to return a blank cell which is then part of a formula that adds up with other cells to result in a monetary value? =IF(MILEAGE6 > 50, (MILEAGE6 - 50) * [MILEAGE EXPENSE]$2) I want values between 0 and 50 to return a blank and not a 0. When I do the above, it messes up the total column because it thinks the…
-
Printing of Web Forms
Hello, The Maryland State Department of Education would like to transition the Notice of Grant Award process from manual entry to collecting requests via a Smartsheets web form. A requirement of this process would be to recieve signature and initialed approvals on a paper printout of the form after it has past through each…
-
Tip for Day to get the team to play.
One of the things that we have done as of late to speed the ability to work in the sheet and for people to move about in the sheet is hyperlink your sub sheets to your master sheet. The Hyperlink creates a fast way to go to anothe sheet without closing the main sheet. If you have you settings correct you can have a new tab…
