-
Automatic inclusion of new sheets within a report
Am I wrong to assume that new sheets will be automatically included in a report when I select a folder level of sheets when building the report? Currently I'm having to manually go back and re-select the folder level of sheets each time a new sheet is created inside that folder. The following screen shots show a before &…
-
Are automations shared with other users when the sheet is shared?
Hello, I have set up a Goods In mastersheet which I will be the owner of. Within this I have set up 13/14 automations to notify different users when they receive a parcel. I have then shared this sheet with the Goods In Manager who will be inputting the data onto the sheet, will these automations also be shared with him or…
-
Formula based on last modified date that skips weekends
Hi there, I'm building out a new sheet where I utilizing the system's "Last Modified" date column. I tried to trigger a workflow off of this column that sends an update reminder if it hasn't been modified in 2 days, but the column is not showing up as an option (presumably because it's system generated). With that in mind,…
-
Tabs
Hi there, Is it possible to create multiple tabs in one smartsheet, like you can with Excel?
-
Auto fill a second column based on a drop down selection using a form
I understand I can likely do this with a very, very long VLOOKUP or IF/THEN formula in every cell, but I'm dealing with over a hundred items and that will be unwieldy. Situation: I would like to have a form where someone selects one option from a dropdown of ~100 items. That value then populates into a sheet. (This seems…
-
Smartsheet User Names - Resource Management - Temp Contractors
Hello - We have one constant email address that gets used by a few people for specific projects, so it's not always the same person. Contract employees - not permanent. I was told that my recurring error in Smartsheet not syncing to Resource Management is due to inconsistent naming within the sheet to RM. What's suggested…
-
Including a checkbox column in formula returns "INCORRECT ARGUMENT SET"
Hi all, I am trying to make a formula that Calculates the hours spent on tasks with certain conditions. I have 2 arguments in my formula that are currently causing it to return this output. Here is the formula: =SUMIFS({Custom Engineering Requests: Days To Complete}, {Custom Engineering Requests: Drawing Category},…
-
Select Different Colors for Select and Multi-Select dropdown results
Hi! It would be really cool if the result displayed in a cel for the result of a drop-down choice could be a different color in that cel. Also, have that be able to change by status/be filterable. This would make it a lot more intuitive instead of everything just being grey. Imagine the below with the ability for Maine to…
-
SUMPRODUCT Workarounds?
Hey all, I'm evaluating Smartsheets for my business and trying to determine whether workarounds exist for some necessary calculations. Three big ones are cost calculation, weight calculation and inventory management. I currently use Excel for these. My arrangement is I have all our products on the top row, with all of our…
-
Cells turning "yellow" automatically
I noticed that if I enter a new comment using the little text bubble icon in a row, that cell turns yellow automatically. Why would this be?
