Hi All! I am looking for some help with a formula that I haven't been able to find in the community already. I'd like to roll up my Status column to the parent rows with the following conditions: Pare…
One thing that frustrates me the most is not being able to remove shared users easily. I know in the User Management section I can type in a e-mail address and have that person removed from all shares…
I'm trying to track new hires via work orders. I'm wondering if there is a way to create the number of rows indicated in a form submission on my tracking sheet? For example, should I indicate that I a…
I am trying to count the number of instances a value appears in a multi select drop down column, but I keep getting an unparseable error. After searching the existing help forum I have tried both the …
We have a reference sheet which has a first column of Client ID followed by columns for Analyst Email and Manager Email (both are Contact List column type). On another sheet we have multiple columns a…
Hello, We are having an issue with cell formulas. The cell formula is erased when we change or delete a value in a cell. Here is the formula we are using: =IF(Status4 = "Complete", "In Progress") The …
Hi Is it a possibility where a column contains checkboxes, for a function to sit behind that that if a lookup to another sheet returns a true value, the checkbox is ticked? Specifically for the lookup…
I am trying to create a Smartsheet to track project completion (Integration) for my company and am running into multiple hurdles with the reporting. I'd love to hear your insight on how to overcome th…
I have a sheet with a SharePoint link to an Excel file in a cell. When I click on that link, it opens by default in the Excel online app. Is there a way to change the default so that it opens in Excel…