I'm using a formula to automate a status column that updates based on dates and/or a "Complete" checkbox. The formula has to reference the task before and I've gotten that to work just fine if it's th…
Hi Everyone, I have a roll up sheet in which we have linked data from individual project sheets. Some data from project 1 will be row 1 in roll up sheet, project 2 will be row 2 and so on. One of my t…
We may have run into a bug with a value on a parent row. The duration of days should be 15 days because the sum of the childrens' rows is 15 (5 tasks, 3 days each), but the parent row displays 25 days…
I manually imported an Excel file into Smartsheet that has hundreds of names as text (no e-mail addresses) which I'd like to use to pull existing contacts in my account. The first and last names match…
Forcing the reset of a user's password is critical to the security and efficiency of any user management system. Every other web service I can think of that uses an admin/multi-user structure has such…
Hello! Would like to ask a question regarding AVG and the ability to only pick up a value if a certain condition is meet. Here is what I'm using. =IF({Call Center_Help Desk Data Priority} = "Level 1 -…
I've integrated MS teams with Smartsheet, but accidently used the wrong login (a GMAIL login, not the right smartsheet login I am trying to integrate with MS teams) I've uninstalled Smartsheet in MS T…
I am attempting to transition our current Intranet over to Smartsheet and the biggest hurdle I currently have is around Policies and Procedures. We are a ISO certified company so document control is a…
I would like to back up a sheet that contains two system generated columns, Created By and Last Modified By, which currently are populated for all of the rows. When I tried saving the current sheet as…
