Hi, I've tried to find a solution for this, but maybe it's a too generic wording problem. We have a Master Project list, that has the start and end date of every project we have, as well as it's budge…
I have a SmartSheet constructed as follows: 1. A dropdown list contains five options to indicate the task status (Column = "Pickup Status"). Pickup Status Pending... Pickup Now Do NOT Pickup Pickup Co…
I am trying to calculate Percentage Complete on a task (Project). I know the Percentage Left (that calculation is working perfect), but the Percentage Complete works on one sheet and not another. =SUM…
I have been researching formulas trying to find solutions without having to tap into the community and duplicate my question with others, however, I really am stuck. Trying to create a formula for RYG…
2 Part Question I want to make 2 employee calendars 1 for vacation another for PTO. Can I create just calendars? I created an installation sheet and a service request sheet. Is there anyway to merge t…
I have a sheet with multiple countif formula referencing data from multiple sheets. From this single sheet, I have created a vital live data dashboard for multiple users to view and make decisions bas…
Greetings Smartsheet Community! I am working on a formula to automate the RYG balls in a status column that references data in the cells of 3 columns, and it seems to be working well. I am wondering i…
I have a MSFT- Promo account and a month ago I created recurring Update Requests that are being sent out to my 17 customers. Since the upgrade last week, I cannot find the Updates that I created but t…
Hi all! I have two questions: 1. I have several conditional formatting rules that change colors or font based on contents. Can anyone recommend the best place to put the "format key" to indicate what …
