-
Using COUNTIF and MONTH() to Find a Specific Date
Hello: For a given set of rows with due dates: 04/03/17 04/28/17 04/03/17 04/03/17 06/01/17 04/03/17 05/17/17 05/17/17 04/28/17 I need a formula that will count up all those due in April. I am working with the following formula, but it is not quite right yet: =COUNTIF(DueDate:DueDate, @cell MONTH(DueDate:DueDate) = 4) Can…
-
Automate RYG Ball based on Checkboxes in Other Columns
I need help from the SmartSheet formula masters... I have 10 checkbox columns (checkbox) and I want the RYG ball to automatically change with the following conditions: * 1) "Red" if no checkboxes are checked. * 2) "Yellow" if some checkboxes are checked. * 3) "Green" if all checkboxes are checked. with one exception... if…
-
Excel rows
how do you get around this limitation??
-
Change next row status when previous row status is complete
I have multisteps to complete an order, Since start of many steps is dependant on the completion of previous steps, Can I program that if a previous steps say row 1 and 3 are complete (status Green), next row status changes to Yellow. I did this by giving code to each row and then with IF statement (If Code of row 1 and 3…
-
Loading files to form or sheet
We have have created a form to allow anyone to create line in a sheet and attach corresponding documents top that line, however it is only allowing 10 files to be loaded. Is there a way to expand the number/size of files allowed to be uploaded via the form? Or is there a way to allow view only users to be able to load…
-
Scroll wheel not working with system settings
I swear I posted this somewhere else, but cannot find it now. Opening a new post. I am able to scroll, but I find that Smartsheet does not respect the settings of the mouse scroll wheel while I am in a sheet or report. If I go to the home tab, or scroll around in my favorites, I can see that one click of the wheel ~= the…
-
Customize a Form
Hi, Does anyone know how to customize a form? Or are we stuck with the basic layout that shows up. We have several forms that clients fill out when they want to request a new report, report changes, Troubleshooting. I have created 3 smartsheets, 1 for each- and would like to have the forms match or be close to what they…
-
Summarizing project KPI´s in symbols
Hi, does anyone experienced how to summarize project data (like deliverables, issues, status and so on) in symbols (RYG balls, arrows)? Do I need a formular for this? I´d like to summarize it to show them at our dashboard. I use symbols already but do not know how to summarize them automatically at the end of the column.…
-
Previous and Next month buttons not appearing in IE
We are asking team members to enter future delivery dates using a Date column. Unfortunately, the previous and next month arrows are not appearing in Internet Explorer. Nobody had complained about this issue until today. Is this a known issue? Other than switching browsers, is there a solution?
-
Salesforce & Smartsheet integration - executing workflows via API
Hello All I'm now investigating Smartsheet & Salesforce connector. I configured "one-direction-only" data synchronization from Salesforce to Smartsheet. It works pretty well - once you hit "Run" button on the https://connectors.smartsheet.com/c/salesforce page. Now I wonder if it could be possible to start synchronization…
