-
Using IF formula to set conditions for RYGB ball color
Hi there! I have been trying to set conditions with a formula to change the color of a RYGB ball based on two columns, the percent complete and the due date. I wish to use the RYGB balls and not just change the color of the cell, which is why I'm using formulas instead of the conditional formatting. I keep receiving the…
-
COUNTIF with Dates
I am trying to use COUNTIF referencing two Dates columns. The first "Due Date" column has dependencies. The second "Dates" column is simply a list of all possible due dates from the beginning of the project to the end (with no dependencies). I am trying to create a third column called "Total Due" that counts how many tasks…
-
Can't identify my Formula error
Can anyone suggest what is wrong with my formula? I get an #INVALID OPERATION result. I've looked at it for too long and can't find the issue. Thanks. =IF(NOT(ISBLANK([Order Date]1)), "Ordered", IF([READY TO ORDER]1 = 1, "Ready to Order", IF([CPM Complete]1 = 1, "CPM Need Approval", IF(NOT(ISBLANK([Vendor Quote requested…
-
Auto order (by date) in Card View
We have a project workload sheet that has columns of who a project is assigned to, completed, and new. There is no sorting or auto ordering of the projects that happen in each column (by start or end date). You can sort rows in the other views, but not card. Help, please.
-
Exporting Red Yellow Green status to Excel (not using words)
When exporting a sheet that uses status symbols (such as the RYG status balls) to Excel, the symbols/graphics do not convert, only the words. How can I change this on the Excel document?
-
Using appsheet with projects
My company has recently started using Smartsheet. We are a pool renovation company and each job is being set up as a separate project. We've been using appsheet for about 9 months now and want to incorporate our Smartsheet data. We want to have an app where our field workers are able to see each task assigned to them from…
-
Check boxes to search on a sheet
I’m trying to use check boxes to search on a sheet. Is it possible to show or hide rows based on a check box entry? Regards Steve
-
Working Days and Holidays for different Resources
Current project settings allow to set-up working/non-working days and length of day in hours globally per project (see screenshot) We have teams from different continents and countries (US, India, China, Germany etc) working on the same project. It would be good to have an ability to set-up working/non-working days and…
-
6 Teams- 1 Dashboard Help
I'm trying to find the best/easiest way to display data from a Sheet Summary Report into a visual Dashboard. We have 6 different project teams, each with multiple tasks or projects with criteria we need to report on as a whole. I've summarized each sheet to give me the specific metrics I need, but now I need to get that…
-
Meeting Agendas - Are you utilizing Smartsheet's Meeting Management Template Set?
Hello, I am relatively new to Smartsheet and am interested in hearing how folks are utilizing Smartsheet’s Meeting Management template set. My organization is looking at potentially using the meeting management template for our meeting agendas and minutes but are running into a few snags. We are considering using the…
