-
Enhancement request - search visible rows only
Is there a search option that will only return results for visible rows? I'm trying to search for something and I don't want information contained within hidden rows to be returned.
-
Forms customization
The required field indicator is a red asterisk. When we built a form, we mentioned that anything with a red asterisk is required - but we can't customize any of the text (including the asterisk) in the description. So the referred asterisk is black while indicating it's red. Perhaps it's minutiae, and the details sometimes…
-
Building Sheet to Alert Past Due Items
Hi All, I am trying to build a sheet that will track when items are turned in to our billing department. If the "turned in"date is past a certain date then I would like for the sheet to send a notification to certain people. The only thing is the "turned in" cell will remain blank until the date it is actually received. Is…
-
Month/Year to text
I am trying to extract the month and year out of a date column and join them to create a unique key. For example the value in the date column is 8/18/2017 I need a formula to return 82017 I can extract the month and the year without a problem, but when I try to combine them I get the sum of 8 and 2017.
-
Using Smartsheet as the only tool vs SharePoint, shared drives and OneNote
Our department is looking at how we file electronically. We have used a combination of OneNote, SharePoint, Shared Drives and we just started using Smartsheet. Smartsheet seems to allow for all communications, files, etc to be stored there. Has anyone moved to using only Smartsheet for everything that has anything to do…
-
Smartsheets for medical practices
Does anyone know if smartsheets solutions can be used to manage medical projects? This would include documenting information that would flow via api into an existing enterprise system.
-
Conditional Formatting Do not modify current value if condition in other field fails
Without creating another column, I am trying to update a current value only if the condition is met in my modified by field. My formula (below) works when the condition is met. How do I tell SS to leave the current value as is if the condition is not met? =IF([Modified By]1 = Owner1, " ", Modified1) Background: Above…
-
Printing All Comments by Sheet
Hello! Is there a way to print all the comments contained in a sheet? Right now, all I can see is the option to print them row by row. Thank you, Sandy
-
Formula to display when a task is late based on start date and status/% complete
I'm looking to develop a formula that will visually (either text or symbol) show when a task is overdue based on a Start Date and the, either, status or % complete. I've tried to combine the RGY or the Harvey ball but that is using only one parameter and I need both columns. Thanks in advance community!
-
=IF formula ???
I am trying to create an alert formula. I need to contact people every 15 days. I have one cell that states "Last contact" and the date, another that states "Next contact"and the date, the third cell, I would like it to state "Contact" in red. Can anyone help me formulate the "Contact" cell?
