Non-profit
Discussion List
-
How to resubscribe on an automated workflowIn Using SmartsheetOne of the users mistakenly unsubscribed from the workflow email notification, how can they be subscribed again to this particular workflow?
-
Counting values in a multi-select column when "Yes" in another column?In Formulas and FunctionsI'm trying to count instances of a specific selection in a multi-select column when "Yes" is in another column. I've tried various FIND, COUNT, COUNTIF, COUNTIFS then IF or AND, but I'm not able to figure this one out. Thi…
-
Copying/Moving attachments to other rowsIn Archived 2015 PostsGood afternoon, I'm not aware of a current way to do this, so I'm wondering if it's on the dashboard for enhancements. In our use, we find ourselves needing to attach/copy the same documents from one line to another and currently the onl…
-
Dates in formula AVERAGEIFIn Formulas and FunctionsHello, I have problem with the dates in the formula below (in sheet summary) =AVERAGEIF([Date of request]:[Date of request], >07.01.2019, [Completed in days]:[Completed in days]) The Smartsheet returns me the value 0 that is wrong ca…
-
Report and Calendar ViewIn Using SmartsheetI created a report from a sheet. The report contains only a few columns. This report is intended to be mostly used for calendar view. The items we want viewable in the calendar are the same items contained in the report -- not the main …
-
Risk Register - download example templateIn Using SmartsheetHi - I am trying to download the very first risk register template that is referenced on this page. https://www.smartsheet.com/risk-register-templates When I click the Smartsheet version, I get a completely different Risk Register. When …
-
Automating RYG balls to change colorsIn Formulas and FunctionsSo i have parent cells and dependencies. The dependencies have color balls (red, yellow, green, grey). Here is what I want: If one of the dependencies has a red color ball, I want the parent ball color to be red. If all dependencies have…
-
Conditional FormattingIn Using SmartsheetI am using a form to collect contact information for event registration. We want our guests to register separate email and phone numbers for each member of the household. Is there a way to create a conditional format that keeps guests fr…
-
At Risk FlagIn Formulas and FunctionsHi there! I am trying to have it so that the flag shows if the End Date is 3 days away AND the Status is "Not Started" (ideally, I would like it to show if the status is anything but Completed, but that may be too difficult). I k…
-
Is having multiple 'events' on the same row or specific days highlighted possible on Gantt viewIn Archived 2016 PostsI'm creating a Gantt chart to monitor and plan my progress for a thesis I am writing. I have the various stages of my thesis with their sub-projects indented under them, so my Gantt chart is becoming quite tall. I also need the days of…