-
How do I join multiple rows of texts into one cell based on another column's criteria?
Above is a screenshot of the sheet I'm currently working with. In each cell of the third column, "List of Tasks", I want to enter a formula that will join all of the text in each row of the "Tasks" column but only include text whose row 2, "Task Completed", states "No". I know how how to use the join function, but not if…
-
Copy rows from one sheet in the same Working space into other sheet Ctr+C/V?
Hi, is it current limitation of smartsheet apps that I cannot copy rows from one sheet into other one under the same working space (like in excel ctrl+C/V)? all the best, Maciej
-
Pre-Populate a form
Hello I am working on a form to collect the Employee's PTO request. However, i would like to prepopulate the Form with the Employee's PTO balance (which referenced from another sheet) I read some articles about using URL, but i don't know how. Can anybody help me with this?
-
How to keep changes in chart colors?
I have created dashboards that include charts, for which I have selected specific colors for each category. Data for the charts come from different sheets. However, everytime I add a new row to the source sheet, I have to update manually the range of data in the dashboard. When I try to update the dashboard range, the app…
-
Pro Plan and Sharing
My apologies, I did not scroll through the myriad of questions/answers here completely. I recently upgraded from the free plan to the pro plan, in hopes of developing something that can be shared and used by others in the office. My understanding is that with the pro plan, up to 10 collaborators can be sent sheets, etc. to…
-
1 PDF that requires two signatures, not sure where to start, kindly help?
Hi all! I'm looking for some very basic help to get started as I'm not sure where to. I have a single PDF form that requires two signatures. The first signature should be from an employee, say "x". The second signature then needs to be of that employee's supervisor, say "y". Once both folks sign, that form needs to go to…
-
Trigger Notification
Hi there, I'd like to have a notification trigger when a box is checked in a "Complete" column for one particular row to send a notification to all contacts in an "Owner" column. What is best practice for this? Owner Column with email contacts Checkbox for "Complete" Column (other checkboxes were formatted to basically…
-
PROJECT MANAGEMENT powerpoint templates
Team, Please let me know if you know of a source for ready-to-go powerpoint templates for some basic Project management documents ( Like Project idea, Scope, Business case, charter etc.) Thanks,
-
Card View Settings is NOT WORKING
I try to change the fields displayed by check/unchecking the boxes, but nothing changes. Cards still look the same... PLEASE HELP
-
How can I include comments in a portfolio view?
I'm hoping to use Sheet Summaries on project plans to roll all project information into a portfolio report, but one thing that I need is a way to have a 'status update'. We use comments and the conversation tab heavily in project plans, so I can pull a 'latest comment' column, but I want to pull comments made for the…