-
Non-reproducible oddities with Save As for Notifications
During my testing of the recent (2017-09-14) release: "Existing Notifications can now be included when choosing to Save as New or Save as Template." I have observed some oddities that are not reproducible, but have occurred more than once during my testing. I'm testing on a workspace with 10 sheets, one of which has two…
-
IF statement help to determine active sprint
Hi all -- just starting to build a library of IF statements... Looking for some help to build an IF statement to determine which Sprint is the current active sprint... Basically, IF Today's date is between [ColumnSprintStartDate] and [ColumnSprintEndDate] then check the box, if the date is not between those, then leave it…
-
Last Contact Date (Date Column)
Hi Team, I have a date column which I enter in the last contact date . Sometime I forget to enter the last date If i do an action..i.e. call, reminder, notes, e-mail etc. etc. Is there a formula that I can build (If I have to add a column and then hide it to make the formula/formatting etc. etc. work no problem) that can…
-
Question about sorting
Hi, i'm looking for some suggestions on an issue that I am seeing related to sorting in one of my Smartsheets. I have a sheet that has a row with instructions to the users as the first row. I have a checkbox column that is only checked off in the instruction row, and I use a sort to keep this at the top of the sheet. My…
-
Suggestion: The Metric Widget should count items in a column
For example, if I have a dropdown of all 50 states, I should be able to set up a widget to count the number of times Alaska was selected, simply by selecting that column and one of the selectable options. If 20 people have selected Alaska, it would read 20. When a 21st person selects Alaska, then that widget would read 21.…
-
Basic Project Management Suite Template
Everyone, I am in the process of creating a set of sheets, sights, and reports to manage the projects for our team. We don't need anything fancy or complicated, just something that will allow us to track our project tasks, project charter information, and a project dashboard. It occurred to me that someone in the community…
-
Sheet to sheet selective data transfer (for new rows)
I currently have two active sheets. The first sheet, we'll call "intake" and the latter "Projects". If I review a *new* row added to "intake" and determine I want to copy it over to "Projects", I need selective data from certain columns on that sheet to transfer to certain columns on "Projects". The columns do not directly…
-
Alert
From a WEB Form - I'm searching for a way to send an alert by e-mail every 15 minutes to a specific "assigned", until a check box have been check. Is there a way?
-
Running formulas
It appears as though you have to open a sheet for a formula to run. Is this correct? I have reports that show out of date data due to the sheet not being opened therefore causing the formula to activate. Any suggestions? Thanks in advance. Richard
-
Filer changes after 8:00PM
Hello, I noticed when I am sorting a date filter by today it will work fine until about 8:00PM. Then the filter switches date to the next day for some reason. So if today's date is 8/16 and then when 8:00PM comes by it will switch the date to 8/17. I will have to change my filter to yesterday to pull up all my data for…
