-
multi criteria for Conditional Formating
Hi, I have a SmartSheet to show the meeting schedule. It has several columns: strata manager, building code,.Supplies given to SM (date) ,Reminder to Accounting department" (this has the formula inside to show the date) I just want to highlight the column of strata manager as green as for the following condition: 1.ā¦
-
One Task with multiple Predecessors
Hello, New to SmartSheet. Question is, I am working backwards, and i have one Task (Task 3) with four Predecessors. These four Predecessors end up having different Start dates. Task 3 ends up having an End date of the Predecessor with the shortest Duration. Shouldn't Task 3 have an End date of theĀ Predecessor with theā¦
-
TIP: Look out for incorrect years in your project plan.
If you find in a sheet that a task is not appearing with other tasks in the gantt chart or the gantt chart is defaulting to a date that is far away from the rest of the project then double check that the year of all tasks are set correctly. For example, ensure that the date 12/01/17 is in 2017 and not in 1917. You canā¦
-
Import Google Forms?
Hello. New user so forgive my ignorance. I'm testing the potential transition of many of my current G Suite functions over to Smart Sheet. Currently, I use a Google form to input daily information which compiles to a Google Sheet. To save time, I would rather import that Google Form rather than creating a new one inā¦
-
Reports
I have several reports built that pull from several sheets. I have rules created for a couple columns so that only specific lines are included in the reports. They all have 50 lines even if there are only 25 lines with information. The rest of the lines are blank and not able to be edited. I have other reports that areā¦
-
Formula puts data left-justified instead of right-justified
I have the following simple formula: =IF([Grasp of Material]3 = "Excellent", "100%", IF([Grasp of Material]3 = "Good", "80%", IF([Grasp of Material]3 = "Fair", "60%", IF([Grasp of Material]3 = "Poor", "40%", IF([Grasp of Material]3 = "N/A", "N/A"))))) The formula puts the 100%, 80%, etc. as left-justified. When I tryā¦
-
Automate Child Row Based on Parent Row
HelloĀ SS community. I am curious to know if there is a way to update a child row based on a parent row. My real world scenario is as follows. I move children rows physically on the page into one of 6 sections contained by parent rows. When I move a row into the 'Completed' section, I would like the status column to changeā¦
-
Formula for a dependancy
I have 5 columns on a sheet that all have check boxes. Is there a formula that will say If these 5 boxes are checked then they have the status of green dot?
-
Using Resource View without 'named' Users
We want to use Smartsheet to build out our sales pipeline (consulting biz) and expected resource allocation. However, we don't have 'named' users (resources) until the project closes and we find the correct contractor. Is there an easy way to utilize resource views but without having named users invited into the smartsheetā¦
-
Sending out sheets automatically
Let's say I want to send out my scheduleĀ every Friday to a few specified emails. Can I set it up to do this automatically?