-
Feb 13 System Update - any new features or just maintenance?
Travis and team, There was a system update on Feb 13. http://status.smartsheet.com/incidents/mjcjfljhffgh And I see the list of maintenance areas affected: "This scheduled maintenance affected: Smartsheet Application & API, System Generated Emails, Search Functionality, Reporting, Resource Management, and SSO (Single…
-
Combining formulas for child rows
I have an easy formula to work out the average data entered into my child rows, the formula is as follows: =AVG(CHILDREN()), this gives me the average of all data put into the child rows perfectly. However, if nothing is entered into these child rows the parent row with the formula in it just shows #DIVIDE BY ZERO. I would…
-
Adding Parent Rows in reports
I am still learning my way around in SmartSheets and need some more help! I have created a report to show all "Past due" actions by owner. The report only lists children as we calculate Past Due status at this level - not at Parent level. Is there any way to include parent rows in this report, even if they don't have a…
-
Auto Checkbox Completion
Hi All, I am trying to get a formula to work that checks a box based on a column with percentage. I.e when 100% is reached the box is checked. I have tried the following to no avail =IF([Compliance]5 = "100%", 1, 0) Similarly I would like to have another column ticked if non compliant i.e <100% again I have tried…
-
Formula to show monthly count
Hi, I am trying to figure out a formula that tells me how many entries have been entered for a particular month. I have a date column and an tonnage column so if I have 10tonne of material made on 1st February i would enter in the date column 01/02/16 and next to it in the tonnage column I would enter 10. I also have a…
-
Combining Formulas
I am currently using 2 columns to identify tasks "Due in Next 2 Days" and "Past Due/No Schedule". I have been trying to nest the two formulas together to get the status in the same column. How can the following formulas be combined togateher: =IF(AND(Due6 <= TODAY() + 2, NOT(Due6 < TODAY()), NOT(Status6 = "Completed")),…
-
Create To-Do Lists for Team from Assigned Tasks
Hi, The company I am trialling Smartsheet for have many projects all happening at the same time. When I assign a task to a team member through assigned tasks, is it possible for this to auto-create a task list for each staff member, like a daily schedule / calendar for who this is assigned to? At the moment the manager…
-
AppSheet Date format
Hi There Although I have set Data locale as English (Australia) the date format on AppSheet is still American Format/ shows 2/18/2016 should be 18/2/2016. Could you advise if this is an issue that can be fixed or a future enhancement? Keep up the great work - AppSheet = Love it.. Regards Wayne
-
Issues with Reports since this today
Hi all, since today my reports are empty.. It looks that whenever I use a specific choice in 'What', the reports does not give back any result. ('Field is blank' works ok, probably because this means 'no choice..) anyone with the same problem?
-
Count Down Formula
Does anyone know a formula that can count down days (for example how many days to an election)?