Hello community, I am using a MAX(Collect( formula to pull in a number from another sheet where I calculate the number of days we have to lock a project's files after completion - this is pulling into…
I know that I can download an activity log from a Sheet, but is there an easy way to build a report off the activity log data? I want to track metrics like # of sheet views, unique users using the she…
I am in construction and the need for fractional formatting is very important. I have seen other community questions from 2017 regarding this but has not been updated. Will there be an option for the …
Hi! I have a formula I have been trying to figure out. I'm getting stuck because I want to make sure that the duration does not include weekends or holidays (if possible) and there is a condition. Any…
Hello- I am looking for a solution to populate a couple hundred contacts into a Contact List for a shared Smartsheet without adding each contact to the sheet's Contact List manually. Here is the conte…
Greetings I am handling a number of projects and making Gantt charts to track their progress. The data for these charts are stored in MS Excel sheets on my local drive. It becomes cumbersome to manual…
I am looking for a solution to create a drop-down list with 125 options, which can be structured using categories to help users navigate and find the right option. Ideally, I would like to implement a…
I have a sheet that gets filled with data from a form, is there a way I can lock the top row so when the form is filled the new row appears below the top row. I have the row locked but new rows from t…