-
Formula Issue
I want to get a dollar amount based on if a checkbox is selected. I am running a program where participants can get gift cards as incentives. I am using a separate sheet for the amount for each incentive. The other sheet columns are named the same as the incentive. Each column is a checkbox. To explain what I want, let me…
-
Options to display all formulas/functions in a sheet
Hi Community, I am a new user and would like to know if there is a way to view the formulas/functions within a sheet either as an ad hoc toggle on/off feature/shortcut or by leveraging the report builder. I understand that we could copy the formula/function body as text to a hidden column for reference or reporting.…
-
Can't see check boxes or symbols. PLEASE HELP!!
Hello, I hope someone out there can help. For some reason today I can't see the checkboxes on my sheet or the symbols when editing the column type. I can't see the symbols on the sheet or in the dialog box that pops up when trying to change the symbol type. I can see symbols in columns on an old sheet where the column was…
-
Adding Nigeria into Phone# Country Code drop-down list
I work for an international non-profit, Society of Women Engineers, and we have some users in Nigeria, Africa that pointed out Nigeria is not an option in the country code drop-down. We would like to see Nigeria added, especially as our organization moves to increase visibility and recruitment in Africa.
-
Reminder automation
Hi! I'm trying to set up an automation for weekly reminders if certain conditions are met / not met, and from what I can tell everything has been entered correctly, yet when I run it to test it seems to fail. Any help is appreciated! Here's a description of the situation and what I have set up: Several farmers markets have…
-
Notification emails with new Proofing feature
My organization plans to start using the new Proofing feature, and today we did some initial testing to see how it works. We noticed that the person who requested a proof review didn't get ANY notification emails when new comments, approvals, or rejections were added to a proof. We tried to set up notifications using…
-
Best Way to Represent Multiple Due Reports?
We are utilizing Smartsheet for Non-profit grant tracking, including for awards that we have received and have reporting requirements for. I am wondering what people's best practices are for something that has multiple due dates and report types. Here is an example of a standard situation: Grant A Narrative reports are due…
-
Formatting Options of Gantt
Is there any way to format the Gantt portion of my view/print? I need to adjust (narrow) the width of the Gantt columns so my chart fits on one page. Also, it would be great to be able to adjust the direction of the column titles (Jan, Feb, etc.) to display vertically, so I can narrow the columns quite a bit. I would also…
-
Formula to count # of dates per month in a date column
I am trying to create a formula that will tally, by month, the number of date entries in a column. (See screenshot attached). Our non-profit provides ongoing financial counseling to veterans and each person is counseled more than once throughout the year...so I want to be able to tally each month how many new veterans we…
-
How to turn on notifications for sign-ups?
I have created a SmartSheet sign-up for an event I am hosting and it looks great. However, I am not receiving notifications when people sign up with the sheet. Instead, I've been refreshing the page every morning. Is there a way to turn on notifications for sign-ups specifically within a sheet? I've already gone into my…