-
IF formula not working
I am having issues with what I thought would be a basic formula. I am trying to write a formula that will look at a date in a column and return a yes/no if it before the current date. The formula I have written is: =IF([column name]@row TODAY(), "yes", "no") According to what I could find it should work, but I get the…
-
If cell checked, pull in different cell value
I'm trying to pull a value from a cell into another cell if a different cell has a check mark. If the cell for the column 'Full Payment Received? is checked, insert the value from 'Amount of Bonus Owed' I've tried the following: =IF({Full Payment Received?}@row = 1, {Amount of Bonus Owed}@row) Thanks in advance for your…
-
Report with multiple source sheets
Hi - Having trouble building a report using 3 different source sheets. They don't all have the same columns, but they have the same primary column. 2 sheets are in the same workspace (let's call these Sheet A and Sheet B), 1 is in a different workspace (sheet C). Even why i try to make a report for Sheet A and B, it is…
-
Publish Reports for Editing
I work with a large amount of people who need to be able to see and edit some things from our smartsheets but we don't want them to be able to edit everything and we want them to be able to find their specific information quickly. If we were able to publish reports for editing, anyone we shared the link with would be able…
-
Why is my chart blurry on my dashboard?
I recently tested the Chart widget and like the functionality, but I can't ignore the fact the text is blurry. People I have shared the dashboard with also have remarked on how blurry the text is. Is this a problem others have experienced? Is there a fix?
-
Automated Columns
Instead of automated rows transpose it to automated columns. So you could up multiple quantities in multiple rows within one column. Similar process automated rows, but you can do columns for a number of desired cells
-
Our first ENGAGE challenge is here - Smartsheet Travel Diaries 🗺️ + Bonus Giveaway
Hi Smartsheet Community 👋 We can barely wait for ENGAGE 2023: Potential Unlocked, so we’re starting early with a fun little challenge. Join in for the chance to earn a special badge. What are the Smartsheet Travel Diaries? We want to see the world through the eyes of our wonderful global Community, and go on a virtual tour…
-
Transfer Backups to a different user?
Hi! We have backups for sheets/workspaces by different users in our organization and are looking to have 1 user manage them. Is there a way to transfer this? Thanks much.
-
Data Mesh Timing & Owner status in Activity Log
1st Question: Does the hourly option work based an hourly run? Or is it triggered an hour from the latest change? 2nd Question: If someone created the Data Mesh and then transfers ownership to you, does it show both of your names when the workflow is run for that app in the Activity Log?
-
What is the best Template
I have been asked to document all my duties so that my new bosses can see everything that I am working on and have a better understanding on when project work will start or finish. Much of my work however are daily/weekly tasks that reoccur but are not fully known in advance. For example part of my job is to process new…
