-
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?
-
Filter Cards by Phase/Title of Parent
Is there a way in the Card View to filter and only see cards within a certain phase or cards that have the same 'Title of Parent'? I have a multi-phase project with hundreds of total lines and it would be great to be able to break up the cards to only focus on the current phase of the project. I'm also open to any other…
-
Automated task status in a project plan
I am building a project plan and would like to have the "Status" to be automated based on the % a team member fills in for a task. I've tried several of the IF OR and IFAND statements and they work partly. I can get the "Complete" and the "Not Started" to work but unable to figure out the "In Progress". When I try to nest…