We have created user groups for different departments and have several forms with a column of users. How do we make the drop-down on the sheet pull from a specific user group? Right now we have to man…
I would like to run a calculation with a circular reference =IF(Date1 = [1]1, 100 - Total1, [1]3). This allows me to keep the cell as is if the IF statement is false. Is this possible? [1]3 is the ci…
Hello, I would like to set up a row of cells to run a calculation at a specified date and time. If that is not tricky enough, I want that calculation to remain as is thereafter even though the data th…
I have been attempting set up a relational database for multiple client use. This database should track records (rows including child rows) as it progresses through different phases. Projects may stop…
I'll try to explain the best I can. I have a customer who will view only a summary sheet in Smartsheet. This info is pulling from various cells in individual Smartsheet store pages that they cannot se…
I have a sheet that we add rows to everyday. One peice of data that is added with every new row is a case number (unique identifier to show us who we are working on). How can I get a total of unique c…
I see back in 2015 there were some posts about not being able to use SmartSheet office Is this still the case? and in so, does anyone have any tricks or ideas to get around this Many Thanks in advance…
Can anyone help us fix this error in opening attachments through google drive? Note that only files uploaded directly to smartsheet from computer experience this kind of error. Attachments from google…
Hello, I started a discussion yesterday but not sure where to find it now. I would like to see if anyone has posted answers to my question asked yesterday. Please Advice. Many Thanks Senthil