-
Is there a formula or function that allows text to be removed and replaced elsewhere on the Sheet?
Hard to explain just in the question box. We have a staffing schedule for our company which allows us to see who is currently on jobs and who is coming up for availability for an upcoming job. We are trying to figure out if there is a type of formula or function that would allow us to type an employees name in next to the…
-
Who gave access to view or edit SmartSheet
Hi, i have this basic question. Is there a way that i as admin can see a log of who of the other admins or Editors - Can share gave access to other users to view or edit some smartsheet or workspace? Thanks in advance
-
Editable Report with Shared Sheet that's Hidden/Locked
Is there a way to make the report editable by the user with a sheet that is shared to them as "Editor - cannot share", but making it to where they can't alter the actual properties of the sheet itself? Thanks in advance!
-
Using Index with Collect to Copy information from one sheet to another sheet for an entire column
Hello, I have 2 existing SmartSheets: Sheet 1: A Master sheet with 2 columns: Sheet 2: Another Sheet where only the "Die Name" where "Is Die 1 New?" = "true" is captured. I have tried the following formula under row 1 under "Unique Die Name" in the 2nd sheet: =INDEX(COLLECT({Die Name}, {Is Die 1 New?}, "true"), 1) This…
-
Frozen/Unresponsive Sheets
We're experiencing freezing/unresponsive sheets after a few moments of being open. This has been going on for a few days. Anyone else experiencing this? Thanks
-
Workaround for Sheet Reference Limit?
Hi everyone, On our project we have two sheets, a project plan which contains around 50 items, each containing around 9 sublevel actions. We have a separate sheet that we were manually maintaining in excel containing all of these sublevel actions organized in rows based on the 50 items. Our goal is to have this sheet…
-
How to create children in large sheet automatically
Hi! I'm new to SmartSheet and not very good with Excel 😪. I have a sheet with over 18,000 rows that I would like to make any cell in the primary column with a date a parent of the rows beneath. I used an excel formula to find and add the date to the Primary column based on blank cells and a separate Event Date column (see…
-
SUMIF Formula Not Working for column with #'s but working with text..
My sumif formula is not working with a numeric value but it is working on a text value.. Here is my formula that is not working: Sheet Referencing: SAP WBSE is the same as Proj. Def. column. I'm asking it to return the Ovr Commit column, essentially 64,345.03 but it's returning 0 but when I sum it on the description column…
-
Filter for contents starting with a 2 or a 6 is no longer working
Searching using Unnamed Filter with "contains" starting with the number 2 or number 6 is no longer is working
-
Copying Attachments Between Sheets
Is there any way to copy attachments between sheets automatically without copying a row? I have a master intake sheet where each row is a different project and attachments can be added. I would like those same attachments to be available in the metadata sheet of the individual project. Basically, the project metadata sheet…
