-
Calculating a day from a date
I've got a column (called "Dates") formatted as dates. I would like the adjacent column to show the day of the week that date falls on. Using the formula =text((Date1), "dddd") brings back an #unparseable error in the cell. I've tried using brackets instead of parenthesis but it hasn't worked. I must be messing up the…
-
Translating Data from One Sheet to Another
I am looking for any method that could help me obtain the desired results. I have a tracking sheet titled “PM Sales Tracking” and within the tracking sheet there is a column that is called “Design Request” I have edited the column properties(design request) to a “dropdown list” with values of “yes and no” depending on the…
-
Linking Sheets
I am working on a master SmartSheet to roll up other Sheets into one. When changes are made in the linked SmartSheets, this is not reflected in the master. If I add additional rows, my master is not updated What I am missing?
-
Sheets
Dear, I now have 10 sheets, can expand to 30 sheets.
-
converting data sheet to format below
Hi, I am trying to convert a data sheet into a widget like the one below. Does anyone know how I can do this? Thank you! Lindel
-
New UI 12-14-2018
This UI is terrible, I don't even want to waste my time explaining why at this point, it is OBVIOUS. At this time I am contemplating updating all training materials, SOP's and videos or just throwing in the towel and searching for a replacement. I simply do not have the time to re-learn, re-document, re-train every time…
-
Am I the only one who does not like the new December 2018 look?
I'm struggling with the new layout and welcome any suggestions. I do not have the dashboard level subscription - just below that, I think. I HATE that I have lost my tabs, and I hate that the menu button ALWAYS takes me back to the RECENTLY VIEWED as opposed to the Home. This new layout just seems like more work to manage…
-
Loss of Tabs
Can someone please explain to me the reason for removing the sheet tabs and changing it to what we currently have now? I understand changes that are less user-friendly up front if they provide an overall better experience or increases the functionality and capabilities of a program. However, in this case I see absolutely…
-
Filter counts after revised UI
Since the UI change was rolled out over the past week, we no longer have the same filtering functionality as before. One of the options that we utilized when using a filter, was the counts that were available. Such as when you applied a filter, it would inform you that there were 23 rows of 40 showing. We utilized this…
-
Auto-Populating One Sheet Based on Criteria of Another
I have a contact form that once the contact proceeds into the opportunity phase (think CRM), I want to automatically have their info populate into another sheet. In the contact sheet, I envision a column titled "Proceed to Opportunity" with two options of Yes or No. If no, they stay as a contact. If Yes is selected, their…