-
Formula to check if cell contains a value from a range of cells
For example, the text in column 4 row 2 is "xxxxx_email address=test@test.com" * The text in column 2 row 11 is "google@google.com" * The text in column 3 row 11 is "1" * The text in column 2 row 12 is "test@test.com" * The text in column 3 row 12 is "2" * The text in column 2 row 13 is "smartsheet@smartsheet.com" * The…
-
notification for part of group
Hi, I have a smartsheet and I heard that I can set up notification rules and applied for all shared users. E.g. My sheet is shared with 20 people. There is a column in Smartsheet, "meeting date". I just want notification is triggered as meeting date is changed to any value. However, if I only want notification only…
-
Formula needed
I am trying to set up a formula that will subtract from a given value, each time that item is found. I have a form that my team will be using to enter data (item) and how much they found (subtract from value). In turn, I need to have a running total of what is still not reported for each item.
-
Archive Comments?
Is it possible to archive comments on a specific row without deleting them all together? I'd love to be able to archive them to be able to read at a later date, but want to just see new / unread comments on each row that we need to take action on.
-
Tracking overall attendance to event
Building 2 different pages, one for general registration throughout the year, another to Track which companies have been to which events. The Registration is coming easy but how do I get it to fill in the Tracking sheet/report? So the Registration will track all the attendees for an event, of which there could be 1-10…
-
Report not following set up description
I have built a report that is suppose to show those tasks that are not completed by the due date. I've set it up to look for "today" or "in the past" when "the status ball is not green". On a few of the tasks it still lists the task in my report even though the status ball is green. Any ideas on how to fix that?
-
Reports - Hide the original sheets
We have master sheets that contain information on all products across 6 factories. We want to create a report for each factory that they then update relevant information for their products. This then allows all data to be viewed in the master sheet. The problem is that the report will show only the products that they have…
-
Notifications
Hi Guys, Im trying to set auto Notfication I have a Project sheet with Date type of coulmn called "Last Updated" I have another text Column Called balance Due I want to Create a notification if Balance due is higher then 0.00 Send Reminder 2 days after the date in the last updated Column and if not do able with smartsheets…
-
Weeks Out Calculation based on Nested IF Statement
I'm having trouble having my weeks out calculation work based on the results of a Nested IF Statement. The If Statement works if I use quotation marks around the results which need to display a date. The problem is that putting the quotes around the results converts the number (in my case a date) into text and no longer…
-
Formula to get data from current week only by day of the week.
I have a worksheet with case information and who these cases are assigned to. I am trying to add columns that will total the cases from each day of the current week. ex. columns with a total count for mondays cases, tuesdays cases etc. thru friday. This worksheet has data for the whole month and all I need is the current…
