Trending in Using Smartsheet
Flagging this Month or Last Month
I am trying to create a helper column to flag something as occuring "This Month" or "Last Month" This is the formula I'm using. =IF(Date@row = MONTH(TODAY()), "This Month", "Last Month") It is saying #INVALID OPERATION. Not sure what I have wrong here.
PDF Attachment Downloads
We used to be able to click one time on the PDF symbol to open our documents, but now have to click on the three dots and then get this menu and select open in new tab. The single click still works if we are opening a Word document, just not with PDF. Is there a way to get this function back?
Percentages not displaying correctly in Report Summary
Hi, In this report. I want to total up a number of percentages coming from different sheets. Sometimes the percentages add up as percentages, sometimes they display as an fraction. The source sheets are all from the same template, so should be formatted the same way, though I have noticed that certain files seem to be…