-
Formula Help
I'm having trouble putting together a correct formula or workflow to do certain tasks. I have a rent tracker spreadsheet and want a formula to basically say "When it's 30 days prior to the Rent Increase Date then automatically turn the Status Column drop down to red. Once the Status Column drop down is changed to green…
-
Reference List of Dates in Column Relative Today
Hello! I have a project I am working on where I've created a little bit of a manual schedule that I'm integrating into a smarter excel sheet, but I'm struggling with a formula to duplicate information. I've attached a screenshot below of my spreadsheet... what I need to have happen is this: I would like to have a formula…
-
Use formula to create name of cross sheet range name in a VLOOKUP
Hi Folks, I have a master sheet that links to a work sheet for each row. There is a unique ID number on each row of the master sheet And each work sheet has a range named using that unique ID number. SO is there a way to look up the ID number in the row, and uee that number as part of the name of the range in the vlookup…
-
Cell link indicator
Hi everyone, Is there away to hide the cell link triangle indicators? Most of my cells are linked and it obscures the data. Thank you
-
assign child rows from parent row
I have multiple parent rows each with over 30 child rows. I would like my "Responsible Party" cell in in each child row to be populated if I assign it in the parent row. I.e. I would like to select the contact (Responsible Party)in the parent. I would then like for each child row under to automatically be assigned to the…
-
Cell Linking Within Same Sheet
Hello... is there a way to link the value of a text-based cell to other text-based cells within the same sheet? I have a project plan template in which there are several fields in my "Assigned To" Contact List column which will need to be populated with the same person. Instead of even copying/pasting, I was hoping to…
-
Resource Assignment based on a Vlookup?
I am creating templates for repeatable "projects." I would like to have a column of "Role Assigned" and set up a table (filled in when the template is used) that associates a specific person (Contact) with each role. Then in each row, a Vlookup would be used to automatically fill in the "Assigned To" contact name from the…
-
Can you do if this then that for auto entry from drop down list
I want a column to chnge its value from a drop down list when a criteria is met. What I am after is a column that is titled "ready for invoice" and is a check box. I have another column named "currently assigned to"that shows the seperate departments on an account and it reflects which department is resposible for the…
-
VLOOKUP to another SmartSheet
When will we have the ability to VLOOKUP a value on another sheet? I link to a cell in another sheet now when the location is static....but in this situation the value is not in a certain cell.
-
Automatic Convert Email Address to Hyperlink
Anyway Smartsheet can recognize the value in a cell as an email adreas and convert it to a hyperlink? Based on value in a cell in Sheet 2, an email address is "pulled" from a cell in Sheet 1. However, its text, not an email address contact/hyperlink. Ultimately, I need to have a way Smartsheet can use the email address to…