-
Where can I put completed, abandoned, or inactive Workspaces?
We have completed projects, or abandoned projects, with Workspaces. We don't want to lose them, or archive them to Excel - especially since the abandoned projects could come back to life one day. The problem is we have so many workspaces, the inactive workspaces are junking up the folder list. Is there anyway to create a…
-
COUNTIF with dates and years
Hello, I am trying to write a formula to count executed leases for 2019 and 2020. I do not have a lot of experience writing long formulas but basically the logic is count if there is a date in the Lease Signed field AND if grand opening is between 1/1/19 to 12/31/19 or 1/1/2020 to 12/31/2020. Can anyone provide some…
-
Click Drag Attachment from Outlook to Cell
Is there a way to click drag an attachment, such as a .pdf or .jpg image file into a Smartsheet cell from Outlook?
-
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,…
-
SUMIFS
I am trying to sum accounts receivable for individual salesmen. I have gotten to the point where I can add if the check box under [Check Received] is marked but I do not know how to sum if a check box is unmarked. So far my formula is returning 0 when it should be returning a over $100,000. This is my formula so…
-
Export smart sheet
Hi, I wish to export existing sheet data by last year month wise, i. e. i am using smart sheet since 2017 to till date, i am using smart sheet to maintain data and with getting updated by team, i wish to be have a data month wise which i haven't saved it on my PC and now i wish to see month wise data. please guide me how i…
-
Need help getting multiple sheets pulled into a single report in the correct order
I have three "what if" schedules that I'm trying to pull into a single report. They are simply named Scenario 1, Scenario 2, and Scenario 3. No matter what order I select them, the resulting report has #3 in first position, #1 in second, and #2 in last. I did a bulky workaround by adding a Helper Column in each sheet…
-
Screen Share Training " Is someone available, I am looking for a few sessions of assistance"
Hello, I am looking for someone to screen share and help me customize some smartsheet functions. Example: Create a "weekly to do list for all my milestone items" across my multiple projects that I have to manage, so I dont forget long lead items or miss details. Please email if I can hire you for remote consult, support,…
-
Hide / Show Columns
It would be really nice if Unhide ALL wasn't the only option. I print info for several different people and some of the columns need to be seen by some but not all. I hide alot of columns so unhiding all just to change a couple is a total pain and alot of waisted time.