-
Incomplete Tasks Count Multiple Criteria
I am trying to account for the number of incomplete tasks for Symbol column types. For example, our 'On Target" column uses the RYG Balls, and i am trying to pull back the number of incomplete tasks based on their color (red, green or yellow). This is the formula i have tried to use based on recommendations from this post…
-
How do I create an automatic updated sheet, that pushes information from other 2 smartsheets?
Team, I know you can do it. I have two databases (same structure, different information), but I need a third that consolidates the two previous. If anything gets added in the sources, it needs to be automatically added in the third. If anything gets UPDATED in the sources, the third needs to get updated.
-
Email from Rule
Hi everyone, I have a rule set up to send me an email whenever a row is added. I'm not sure why, but when the email comes through, the fields are highlighted in yellow. Is there a way that the information comes through without being highlighted? Is the rule correct? Attached are images of the email and the workflow. Thanks…
-
Mail Merge with Google Docs: combine into one file
I'm doing a mail merge using Google Docs, which works fine except when I try using 'combine into one file'. I've seen a previous discussion where the pagination was an issue but mine is fine except it changes the font! Can anyone tell me where I'm going wrong? Thanks!
-
Formulas Not Autofilling With Form Submission
I'm having some issues with a formula that refuses to autofill with a form submission. The form is submitting new entries at the top of the sheet and I have two cells below it that contain the formula. According to this help article, it should be autofilling the formula into the new row. What has been driving me crazy was…
-
Can I change tasks visibility in a shared smartsheet?
Hi, I am trying to find out the best way to work with smartsheet in a particular scenario. I have project smartsheets that outline project milestones, and tasks within. This sheet is shared externally to my team for collaboration. In many cases, some of the tasks might drive subtasks, or small actions that the internal…
-
Is there a way to automatically copy filtered content from sheet A to sheet B daily?
I have a sheet (sheet A) that is my source sheet, and the content is updated frequently. I'd like to filter sheet A on a particular column, and copy the filtered content to another sheet (sheet B) to share with my users, automatically at a daily basis. Before copy, content in sheet B needs to be cleared. I tried to use the…
-
Import related data into Master registration sheet?
Hi all! I am making a registration form for students who will be attending a summer camp. Because they are minors, we need agreements (I am structuring these in a simple "check the box if you agree to the code of conduct" format ) from both students and parents. The catch is that students and parents may not be filling the…
-
Proofing- Previous Versions
Hello everyone, I have been using the proofing feature in our team for internal proofing. I have an issue where as soon as you add a new document version, the previous versions are no longer visible they sit loading. You can still download the older version you just can't see them on the proofing panel. This means you…
-
Do dashboards and reports count as 'sheets'?
Hello All, Due to the limit of 100 sheets per user on the business plan we often try to spread the sheet ownership between the licenced users. What I haven't fully figured out yet is whether dashboards and reports take up 'sheets' or whether your total owned sheet count only refers to actual sheets?