-
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")),…
-
Sorting from a drop down list that parallels parent row hierarchy?
I use the sales pipeline by stage sheet and love it. Typically, we manually move rows between our stages, which are set up as parent rows. I use the stage as the parent so I can easily keep track of my totals, which gives me trigger points for action on issues when sales may get slow. I also derive all of our sales…
-
Login History option to open into smartsheet
The only option to see the last 6 months logi in history is to download an excel file... surely smartsheet coud have an option to open in smartsheet
-
Drop Down list in web form out of sequence
Good afternoon, I have searched the knowledge base to no avail, so... I created a simple web form with a drop down list containing 3 times: 9:00 am, 9:30 am, and 10:00 am. The column in the sheet with the drop down list is in order. However, when I created the form and previewed it the times were displayed in this order:…
-
A cell showing current time and date
Hello, Is it possible to have a cell showing the current time and date? Or alternatively, one cell showing todays date - and another showing the current time? I actually accomplished this last year, and have since deleted that sheet, and cannot remember how it was done... I found a work-around for it last time... aghh!…
-
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…
-
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…
-
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?
