-
Daily Email Notifications - Send Time?
I've set daily notifications for automated workflows. What time do those daily notifications send? We have users in U.S. and Asia, so I would imagine they would receive daily notifications at different times based on their Time Zone settings?
-
Was there any changes on my sheet today?
Hi there, Is there a way to check if my sheet had any changes today? (Besides the cell "View History") Anyone please assist. Thank you!
-
Issue with adding Charts to a Dashboard
I had responded on a thread a week or so ago but I am still having issues. I cannot select "ok" because it will not stay "blue" and allow it to be clicked. Is there a fix in the works? I think this has been an ongoing issue.
-
Numeric Values from form unexpectedly converting to currency
Hi, I have had a sheet with form I've been using for a few years now. Just in the last month, a couple of the columns have been displaying data incorrectly. I have customer numbers that can contain a prefix of $. These are now converting to currency format. So customer $3131231 is showing up as $3,131,231. I also have…
-
multiple IF OR statement help
Hi Can get one IF OR statement but need help with multiples please... =IF(OR(Name2 = "Alex", Name2 = "Dana",Name2="PAt"), "Jo" OR (Name2="Adi", Name2="Mal",Name2="Mark "), "Angela" OR(Name2="Sophie", Name2="Amy", Name2="Elle",Name2="Dan"), "Mary") THANK YOU!
-
Can a read-only account export data
We are losing our account data at the end of this week, and will move to a read only account for 30 days. Does anyone know if we have a read only account if we can still export the Project data to Excel and such like, or once read-only you cannot do anything?
-
WBS in smartsheet.
Hi. Is there a way that I can have a dewey decimal system kind of the numbering for the items on my worksheet. I have found a solution that lets me have items numbered in the format 1.1 and 1.1.2 and 1.1.2.4 etc. But I want a system where I can have the format 01.00.00.00 and 12.04.09.11 etc; How do I make sure that there…
-
Form Automation
Hi, Not sure if this can be done. I've created a form that I want to send to users. Ideally, one person would fill in the name of the project, then through automation, send the form on for other users to continue filling out (with the project name already filled out). Or have the person fill the name in the form…
-
How do you apply the same conditional formating to multiple cells?
In excel I can create a formula in a cell, then create conditional formatting on that cell. For example, I can do a quick formula to compare to values. If the value is <0 apply a format that makes the cell red. I can then cut and paste that cell into any other cell I want in a spreadsheet and it gets the formula and the…
-
SUMIFS to Calculate Values for a Specific Year/Date Range
I am trying to use SUMIFS with multiple criteria, and I am failing horribly. I seem to be having trouble when I try to add the criterion to sum data from a specific year (from a Date field) and/or when I attempt to add data from a date range. I have searched the community questions, and I haven't been successful in finding…
