-
Using the Updates Feature with Formulas
First of all, I want to say thank you for updating the "Manage Alerts and Actions" Section and the sheet level option for "Request an Update" I now have the option to set this on a master sheet and not have to recreate the alerts in every new sheet. I have figured out that we can add a column with the formula "Today" and…
-
SUMIF with date range and dropdown list categories
Hi everyone, So I have columns Type (dropdown list, 3 values, Tools, Chemicals, Clothing), Date and Amount ($). I am trying to come up with a formula to sum amount of $ spent in a certain month in each Type of expense. So, for example, for much was spent in type Clothing between 06/01/18 and 06/30/18. Is there a way to do…
-
Toolbar Inconsistencies
I have created a "Master Sheet" that I have to import each day and have linked up other tabs/sheet to that Master Sheet to filter out on the information my technicians need to see. On the Master Sheet I have the full options on the toolbar, but on the linked tabs/sheet there are hardly any options. For example, my…
-
Community Link in Help Menu Gone?
Hi all, My memory may be failing, but didn't the Help icon used to have several entries including a direct link to the Community Forum? Today when I clicked the ? icon, there are only two links: Help & Learning and Show Help Tips. Not a big deal, but that's one more step to get to the wealth of knowledge that the forum…
-
Task sheet check off box
When I try to check the done box in my task sheet it takes me to the edit page and I have to check it from there. This only happens when Im on my smart phone. From my computer I can check the box with out it going into my edit page. Is this supposed to happen? Can I change it?
-
Contact list and look up table
Hi, I am trying to set up automated alert to an area manager that is associated with certain stores. (Several Stores and several managers) This information is driven by forms and the only information that is chosen ( for this part) is the store name. I have managed to create tables and formulas that then auto populate the…
-
Can Viewers hide or filter columns that don't pertain to them?
My team has a spreadsheet that is shared internally (editing access) and externally (viewing access only). For the external partners that use the sheet with viewing access only, is there a way for them to hide or filter to the columns that pertain to them? They need to see all of the rows, but not all of the columns.…
-
Clear cell data based on dropdown selection
HI, I need to clear a date in a cell when a dropdown list selection is set to completed. This will then in turn remove the notifications from appearing and removed the conditional formatting used a visual tool. Ive tested an IF statement on the date cell, by adding the IF statement, adding the date and then selecting the…
-
Sights separator lines
Hi All! Could someone tell me how to add kind of separator line like this one? It is sight from smartsheet's template. It is fully interactive, so if I want make it wider, it is enough to drag the corner of this field. I tried to add a picture of a line from an icon, but it does not expand its width.
-
Transfer exet document to smart
Hi, I have to transfer excel doc. to Smart. Never work with Smarrsheet. I do not know how to transfer taps and all formula they have, they also all link to each other.