-
No longer receiving reminders/notifications
I have not received reminder emails or notifications in the app for any reminders/alerts since 5/22/2019. I have checked my notification settings, my spam folder, I keep running tests, and so far I can't find an easy solution. I've attached screenshots that show my notification center, card view showing active reminders…
-
How can I create drop downs with selections based on a previous column?
For a product management file, I want drop-downs to be limited based on how a previous column is filled out, as it would be a massive dropdown list otherwise. For example, if "fruit" is selected in the "food type" column, I want the next "sub-type" column to have a drop down list for apples, bananas, grapes, oranges, etc.…
-
Set a flag 90 days before due date and after due date
I am trying to flag contracts needing renewals. What am I doing wrong? =IF(OR([Contract end date]1 <= Today1 + 1 - 90, 1, 0))
-
Email hyperlinks not displaying as typed
Has anyone else experienced trouble with the way email addresses and websites are displayed in cells? Example email address typed into a cell: Support@companyname.com What it changes to when you move to a new cell: <a href="mailto:Support@companyname.com">Support@companyname.com</a> It doesn't happen in all cells, seems to…
-
New User: Form Creation
A new user here. Can someone confirm? Can a FORM be created from an existing sheet, or does the FORM create a sheet, and then additional columns can be added to that sheet?
-
Smartsheet connections with count
Good afternoon, I am trying to see if it is possible to connect 2 smartsheets and have one supply the results from the team working the data. IE: Business Partner submits request for an area with a unique area ID to be reviewed via a form. Our team then uses the form and goes order by order to review and validate the…
-
Barcode Scanner not showing Barcode Picture
I am trying to update our inventory system to Smartsheets and I want to take a picture of a Barcode and instead of geting the picture of the Bar Code I am getting just the numbers. How can I go about fixing this?
-
Countif formula for time
Hi all, I am trying to find a formula to count the number of times a time appears that is over 30 minutes. The times are all listed in Column 21 in the following format: 0:15, 0:27, 0:13, 0:20 I have tried using variations of the below formula but I get error messages. =COUNTIF([Column21]:[Column21], >=0.30) Anyone have an…
-
Limiting input in a column
Hi There, I was wondering if anyone knows how to put an entry limit on a column field. I am circulating a sign up sheet and need to limit the # of spots available on a particular time slot otherwise I would have an overflow which I could not accommodate Does anyone have any suggestions? Thoughts? Thank you
-
Reports not showing data from Sheet in cells.
I have two Sheets; one for a project’s status on all services, and another Sheet for all the details of the project, with “Project Name” linked in both sheets. I go to make a report for one of the services, which pulls data from both sheets (or SHOULD at least). In the Report Builder, I choose the two sheets in the…
