-
importing .mpp file
Hi I am not able to import the MPP file correctly in to smartsheet, please help. Any tips to import it correctly. The lines are off. Thanks
-
Compressed (zipped) Folder is invalid
Hi, Since last week if I want to open the zip folder from the download backup link it gives me the following error. Please assist. Y
-
Need help with Parent Status
I would like my parent status to be RED when ALL children balls are red, yellow when at least one is yellow, otherwise green. I found this formula below in a thread, but I can't seem to get Parent to RED when ALL are red. Can someone tell me what is missing? Thanks! =IF(COUNTIF(CHILDREN(), "Red") > 0, "Yellow",…
-
Send Row Default Fields
Greetings, Will there ever be an option to save the "Send" (by row) "Include" options to be reused. I found a work-around to create a report with only the pertinent fields, but this is unwieldy. Example: When I have a support ticket to answer, I do not want all of the fields to display in the email and going through and…
-
Automate RYG Balls based on % complete and start and end dates
I would like to have the RYG balls automatically adjust based on the percent complete and start and end date. For instance, if my task is set to start on 10/2/17 and end 10/13/17, if my % complete is less than 50% by midway between the two dates, to turn yellow. If my % complete is less than or equal to 90% by the end date…
-
Forms
I am literally new to Smart sheet and feel very lost. I am trying to send out a form for meetings and then they would reply on SS as to wheather they were going to attend or not? I am notified of changes and the responses go to a different row and it does not show date of response or a name? What am I doing wrong?
-
Formula for Date column based on status change
I'm looking to create a formula to automatically put a date in a column based upon certain statuses in a dropdown menu. For example, I would like that day's date to populate when the status is 1, 2, or 3 but not 4 or 5 (we have about 10 different statuses in our actual list). Is this something that is possible?
-
Lookup function in Countifs statement?
In my sheet I have a list of projects with various statuses and I need to do summary numbers by month and reduce the number of statuses to 2 (scheduled and unscheduled). I know how to do this if I use the Lookup function to populate a column with the converted statuses, then use Countifs to get the numbers for each month.…
-
PMO Set up - Portfolio / Multiproject Management
Hello Smart Users I recently started as a Project Management Office Manager at a company which provides stored energy solutions for industrial applications. I'm about setting up a PMO and would like to connect with you to share thoughts if you were willing. Any comments will help. I am not new to Smartsheet... using the…
-
Auto filling with formula....
I have a situation where I've added a row so I can format the row I want. For example... A1 is my dollar row which is where I put all my figures for the jobs I'm pricing. B1 is the row I plan on hiding and its where I enter the formula =IF(a1="","Empty",a1) then I use conditional formatting when "Enter" as per the…