-
Formatting when exporting to pdf
Hi, Is it possible to create a pdf report based on one form entry? I know I can send an email confirming what has been entered on a form, however I would like to make this a pdf attachment rather than the body of the email. Lauren
-
Formula to restrict the parent row status from being complete unless all child rows are complete
I need it to also take into account that some don't have child rows. Here is the formula I'm using, however, when a row doesn't have any child rows it is triggering a not started result. Could someone assist? Any help would be much appreciated! =IF(COUNTIFS(CHILDREN(), "Not Started") = COUNT(CHILDREN()), "Not Started",…
-
CountIf NOT equal to 100%
How do I create a CountIf function for all cells that DO NOT equal 100% under a percent complete column? I tried the both of following but they do not work: =COUNTIF [% Complete]:[% Complete], <> =1) =COUNTIF [% Complete]:[% Complete], <>1)
-
Gantt Chart status bar doesn't appear to reflect progress
Our PM's are experiencing a few issues with the Gantt Chart, and I hoping someone can help. In some instances, per the attached, the overall status suggests that the program is ahead of schedule. This is despite Sub-child 2a being on target. Any thoughts why this would occur? We also utilise a formula that suggests how may…
-
How to display today's line in report timeline widget ?
Hi all , I have set a timeline report in which a today's line is displayed ( doted line ) , but when I insert the report in a dashboard , this line is no longer displayed . Can you help me ? Thank you in advance !
-
Signatures on Forms
We would like to get employees to sign after they have been asked some questions via a Form. The Form will be filled in on an iPad or phone by Site Foreman and then the employee would need to sign acceptance. Is there a way to do this?
-
Keep a date when something change
I have a cell with a dropdown list, I want that smartsheet memorizes the date when I go from one option of the dropdown list to another one. I have no idea how to do it Thanks for your help
-
How to create a template smartsheets which all deadline dates change automatically to the new year
I have a working document that I would like to create a template for so that all deadline dates change the year automatically when the new calendar year begins. The month and day must remain the same, just the year must change based on the new year value. Anyone know if that is possible please?
-
Forms duration stamp
Is there a way to add a START and END timestamp to the Form/Sheet that will enable me to determine the duration it has taken for each respondent to complete the form?
-
Working Days Configuration for an Organization
Hello, Working days and non-working days are configurable on sheet-level and account-level, but I wonder whether we can configure that on the organization-level. I want to set the default non-working days and public holidays for my organization then let my team members edit their own paid holidays on their accounts. How…