I'm trying to create a single sheet that has multiple audits from 4 facilities. I am finding problems in trying to have smartsheet count the amount of cycles in the audit. The information is being inp…
Three columns used are Duration(dependent), Projected Duration(I initially copy all of the durations over when setting the project) and +/- days(calculates the difference between Duration and Projecte…
I would like to be able to re-order my sheet without the parenting hierarchy in place. I was thinking that if I create a live copy that is always up to date but does not have the parenting information…
I really like the Card view and how you can show different fields or parents of things in the description. I would very much like this to be added to the calendar view. Defaulting to the primary colum…
I have been working on a Smartsheet for my client - I am a licensed user on their system. I had just tidied up all my reports and old sheets…. and disaster! I can see the structure of my plan, but it …
Hello, We have a basic retail business selling iPhones and what I would like to do is create some type of formula so when I enter a sale into my Sales Sheet it will link to my Box Inventory Sheet AND …
Hi Folks - I'm trying to write a long formula that evaluates nearly 40 criteria then based on that criteria assigns a score. Is there a limit on the number of IF statements and if so what is it? If th…
I have a web form which users use to create a new line item that requires approval once added. An automatic notification must go out to the person that needs to approve. Thereafter a notification must…
Hi all, I built a filter to show my tasks that are due today with a green highlight. However, it does not capture tasks that last across several days (see the different shades of green in the attached…
Hi, I have a situation wherein a developer is working across 3 projects, with his loading being: 1. Project1 - 50% 2. Project2 - 25% 3. Project3 - 25% When i plan his task for Project1, i need to ensu…