-
System Column - Last Modified
Hi everyone! Im having issues with a status column. My goal is to update the status if a job has hit 10 days or more and has not been approved yet. I was going to trigger it by using the (system column) "Last Modified" Here's the problem: If someone only "views" the sheet & doesn't make any updates, every single row in the…
-
Searching a column in another sheet
Hi, I'm trying to reference contact info from one sheet and have it show up in another as I type. I want the second sheet to search a column as I type and match the contact name if it exists. Does smartsheet have a vlookup or something that can search another column in real-time as I type. An alternative would be a drop…
-
Forgot the name of a tool to use
Hi, I thought I saw something flash up awhile ago about a way to build a site/page or something like that that can be used to keep stuff on per project. Almost like a social media thing. I cannot remember the name of that to look it up so I can learn how to do it. I hope someone understands what I'm trying to get at. :)
-
"Recently Opened" Navigation bar Question
Hello All, I have been a huge fan of the "recently opened" Navigation tab and have about 30 sheets pinned. I do use various sheets at various times, however, and would like to rearrange the order of these sheets as well as be able to bucket them. I understand that this wasn't quite the point and workspaces/sheets were made…
-
find and replace text in an already created update request.
I have update requests set for each employee's annual review. I would like to change one bit of text in the preformatted email. Is there a way to do this? Specifically, the line reads: Contact Mary Beth or Jesse. I would like to remove 'Mary Beth or' Is there a way to do this without opening each request individually and…
-
Countifs with find
I have 2 columns (Stage) and (Courses) Courses is a multi dropdown, stage is a single drop down. I want to count how many people are invited to Fundamentals 1 vs how many have completed or certified in a rollup sheet. I am either getting unparsable or invalid This is on a rollup sheet that points to the working sheet.…
-
Comments - Keep important ones on top
Hello, Are we able to lock comments on rows or sheets do that they stay to the top?
-
Filter sheet level attachments
Can anyone tell me how I can filter to show only sheet level attachments (i.e. attachments that are not attached to a specific row but instead are attached to a sheet)? At the moment I have to manually trawl through all attachments in the attachment side window to find them :-(
-
Help with Vlookup + date
I explain, I need to create an expiration date from a drop-down menu where the different types of payments of my clients are informed. Example, if a customer's account is "up to date" it means that the due date will be the issue date + 0. Also if another customer has a "credit" deferred payment type, the due date must be…
-
Filter suddenly not working
Hi All, I have an issue of a filter not working that previously worked fine. The filter looks for cells in a column formatted for text/numbers. Here's an example of the data in the column: NLOND_3104-1 NLOND_3709-2 -2 -1 -2 NLOND_5612-1 The filter looks for data that contain -1 and another filter looks for data that…
