-
Counting two things for a formula
Hi there! I'm a little stuck on a formula and could use some help...I'm looking to count the following: Under Numbered Sites Inactive, I'd like to separate it by opted out and selected out. So I'd like to count two things from the source sheet: The column with the "numbered site" has a number assigned to it (so…
-
Change Formatting in Reports
It would be very convenient to be able to format a report different than the sheet. One purpose of a report is to bring multiple sheets of data together, but often those different sheets have different formatting which can make your report look awful. If you could format your report at the report level, it would solve all…
-
Issue - My Assigned Task Report Attachment
Hello, Please share this feedback with the appropriate engineering team. When scheduling a recurring delivery of the My Assigned Task report via the Send as Attachment feature, the attachment populates tasks assigned to me (the sender) instead of the recipient. We are currently embedding the link to the report in the…
-
Adding attachments from Gmail
My company recently migrated our email to Google Workplace Mail. We previously used Outlook and I was able to drag an attachment from an email to a Smartsheet row. Why am I no longer able to this? I'm aware of the Gmail add-on but its more than I need. I just need to drag and drop. Thank you!
-
CountIF Series of Checkboxes, up to last unchecked box
Hello, I have a sheet with a series of 6 check boxes for different tasks. A team-member checks a box when an operation/task is complete. Some tasks can be done concurrently and are not dependent on another, but I would like to indicate the last completed task up until the next blank check box. Example 1: Checkboxes 1-4 are…
-
Can I create one workflow to notify multiple conditional paths or does each condition need it's own?
Hello, I am trying to create a workflow where specific people at a given project are notified when a request is fulfilled. I have set it up as it appears in the included picture but I am only receiving alerts when the first project is selected. Do I have to create a separate workflow for each of the projects or is there a…
-
How can I add a percentage column that tracks progress of each line item that is considered a "Task"
I'm creating a project tracking sheet that tracks the progress of multiple projects. However, I've been asked to track completion of a project by using percentages. I'm not sure how this is done. I have a Start date but the End date only appears once I enter it in.
-
Only Show Row if Data is in Specific Columns in a Report
Hello, We have project names, resources, and project managers all listed on the same row with the hours worked on particular days. I'd like to build a report, or a sheet that only shows rows if hours are listed past a certain point, meaning only show rows that have hours listed in the date columns. This will eliminate a…
-
COUNTIFS with multiple criteria
I am trying to count the number of projects with a due date in the past and a Status of In Progress, In Review, or On Hold. This is what I have, but it returns unparseable. =COUNTIFS([Requested Due Date]:[Requested Due Date], <=TODAY (), [Status:Status, ="In Progress"], [Status:Status, ="In Review"], [Status:Status, ="On…
-
(New User) Creating a report from Multiple sheets under workspace
Hi everyone, I am trying to create a report that can be sent via email on a weekly basis consisting of the information listed in the attached. I am thinking there must be a way i can get these sheets to be emailed in pdf to myself once its updated by the required person. Any suggestions?