-
Smartsheet Reporting
Hey all - I am attempting to build individual reports for users in our account. I am having a bit of an issue setting up the parameters of the report as I'm not too sure how to build it out. Is reporting only pulled from the column sections? If so, if I needed to pull reporting for an item on a row, how exactly could I…
-
Row Headers Not Aligned
Been using Smartsheet for about a year now in fully up to date Safari OSX 10.12.4 Suddenly yesterday the row headers do not align with their respective rows. Anyone else had this problem? Thanks in advance. David
-
Counting Total Number Correct of RYG Balls per person
Hi Can anyone help me with my a formula that will allow you to count the "Green RYG balls" which means completed for our purposes. I am trying to count the number of completed "Green" RYG balls, per person in order to use on the dashboard I am creating. I trying to display how many tasks has "John Doe" completed and I only…
-
Sights: Sheet Name Link issue
I am having an issue with my Sights where I have a Report Widget and within the report is the "Sheet Name" link. From the Sight, the first time I open, the Sheet Name link does not work. I have to first click in any other column to open the Report, and then the Sheet Name link will take me to the row on the Sheet. I can…
-
IF Statement Help
Hello, I am new to Smart Sheets and apologise in advance if this is a simple question... Scenario: I have a sheet that is updated via a Web Form and i would like to have a Job Status updated depending on a few conditions: IF the Operator is equal to Unassigned then the Job Status is Unassigned IF the Operator is not equal…
-
Copy row from sheet to another on the app
Hi everybody , I can see that feature to cut/paste row in sheet to another within smart sheet app but copy option is not added it . Please , to add copy feature as well for us its very important to move data between sheets , thanks
-
SUMIF
I am new to smartsheet so this may be a simple question. I want to sum up the total hours of a project based on the status of the column. I.e. total amount of hours complete, not started etc. The 2 colunms I am interested in are Status (on track, complete etc) and Duration I have tried this ...…
-
Need Standard Template
Dear Smartsheet Team I need your assistance to get standard template of all the Fields of Hospitality such as project management, Sales and Marketing, reservations, Accounts and Finance, Admin and HRD and Operations Department. Hope to hear you soon, i need your assistance for better usage of Smartsheet. Regards Ashish
-
Update request with job name ( or sheet name)
I have 4-5 jobs ( or sheets) going at the same time. I've sent out update requests and unless I remember to edit the subject line with what job it pertains too, the recipient at a glance doesn't know. They have to click on the request to follow to the sheet. Any way to get the sheet name on there someplace automatically? (…
-
Transferring sheets to other owner
We have an enterprise account. When someone leaves, I move their sheets to another person. I need to have the functionality to look someone up vs. having to scrolls through literally hundreds of names. Ideally, in addition to being able to look someone up, I'd also have the ability to transfer the sheets to more than one…