I'd like to apply different weightings based on a staff members role on the staff sheet. I have a weightings sheet that defines the weighting for each task per role. I can't work out how to write an i…
Hello All! I am stuck trying to fix the automation of my RYG balls in Smartsheets! I need to add one more IF formula to be the formula below so that if a task has not yet been started, the ball will s…
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 …
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 Lea…
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 a…
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…
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…
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…
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 ha…