-
Parent Row Symbols based on highest priority?
It is possible to create a formula that will change the symbol to represent the HIGHEST level out of the 4 rows? IF the (HIGHEST) Risk Level for rows 1-4 is "x" THEN action for symbol column is "low" = blue symbol is "medium" = green symbol is "high" = yellow symbol is "extreme" = red symbol I currently have a formula to…
-
Emailing reports, except for when blank
I have a report pulling data from several sheets inside my workspace. Essentially it emails the report as an attachment every morning at 9am to my team and lists out open project needs. The question is there are some days when the report is blank (ie. no open project needs). Is it possible to: * not send an email if report…
-
Count the number of projects in a folder
Our team is looking for a way to count the number of projects of three distinct types. I have them located within three different folders. I do not want to have to use cell linking. A user should be able to create a new project without having to open a summary sheet and create a new cell link. If I could use a formula in a…
-
Formula HELP!
Need Help! I need a few of formulas. (1) Formula to automatically populate a due date (2 weeks after start date). (2) Formula to calculate duration between two date columns. (3) Total parent rows (projects) and total based on parent color. I'm at the end of my wits! Thanks everyone!
-
Help with Column Edit Permissions
Hi All, When I share a sheet with my associate (or visa versa), the person who did not create the sheet is not able to edit the column properties. They are 'grayed' out. I checked and it looks like we both have the same permissions, so Im not sure why that happens. Any advice would be appreciated! Thanks, Robyn
-
Cell Linking Autofill or other means when sheet too big
I sent in a comment to Customer Success that the sheet is getting slow performance. The response was bust it up into multiple sheets. Well I like the idea, I'm not sure I like the solution - it make everything now manual unless someone can tell me a better way. The first four columns in my Master Sheet would need to be on…
-
Setting up a recurring meeting notice
Can anyone tell me if it's possible to set-up a recurring weekly meeting within smartsheet for about 15 participants and include weekly agenda items? Thank you.
-
Smartsheet Reporting
Hey all - I am attempting to build individual reports for users in our account. I am having a bit of an issue setting up the parameters of the report as I'm not too sure how to build it out. Is reporting only pulled from the column sections? If so, if I needed to pull reporting for an item on a row, how exactly could I…
-
Separate effort and schedule for project planning
Hi folks, I am wondering people's experiences creating project plans that include separate estimating and tracking of effort versus schedule. A simple case has a task done full time, with full resourcing, with no delays or wait times. In this case, the Smartsheet "duration" works fine for both effort, duration, and…
-
Row Headers Not Aligned
Been using Smartsheet for about a year now in fully up to date Safari OSX 10.12.4 Suddenly yesterday the row headers do not align with their respective rows. Anyone else had this problem? Thanks in advance. David
