-
SUMIF problem - "#incorrect argument set"
Hello, I am getting the "# INCORRECT ARGUMENT SET" error when using the following formula: "=SUMIF({Treads Extruded 2019}, MAX({Week no.}) = [Current wk no.]1, {Production Qty})" I have attached an image of the table I am working with, removed any sensitive information. I want to add all of the production quantity up for…
-
Customise alert email body
Is it possible to customise the body of an alert email beyond choosing which columns will be displayed. I need to be able to hide the name of the sheet in the body of the email as I want the receipient of the email to visit a report to view the details rather than the original sheet.
-
Best practice for an Employee on-boarding process
Hi - new to Smartsheet and my MD and HR Director have asked me to look at rationalising some Google Sheets they use at the moment to track employees from initial interest through to starting with the company. I've looked at a couple of templates and started down the road of creating a sheet which has Surname as the Primary…
-
Auto move column info
I'll try to explain the best I can. I have a customer who will view only a summary sheet in Smartsheet. This info is pulling from various cells in individual Smartsheet store pages that they cannot see. This summary is set up in a "One store per Column" arrangement. As the store page info is populated, various info…
-
Gantt chart, how to color weekends in OTHER colour than grey?
I have seen some post regarding the possibility of changing the colour of the columns marked as "non working days" and all suggestions to solve this seems to point to the possibility to change the colour of rows. So, I am again asking about the possibility to change the the colour of columns to enhance the readability of…
-
Web Forms
Hi, I wondered if anyone can help me with the following web form queries:- * Is there a way of showing, on the Smartsheet, the text you enter in the ‘Help Text’ field in the web form? * If you are awaiting responses from a certain number of people, how can you monitor which are still outstanding? * Can you prepopulate…
-
Slack Connection went down
Hi, We have both email and Slack notifications set up to notify project managers when creative requests come in. Last Thursday I renamed the Slack channel, and the PMs stopped receiving notifications through Slack. I received an error message stating the rule was invalid, so I updated to connect with the new Slack channel…
-
Is my data forever lost?
I had a Smartsheet account for a couple of years. I discontinued a while ago but I tried to log back in today to recover old data and the old data appears to have been wiped out.
-
Resource and pooling resource.
Hi, Does everyone allocate tasks to individuals, or does anyone use a resource pool? for example, if you build a project and need a Quality Engineer allocating to the project, can you allocate to a Quality Engineer pool to show you need a Quality resource, and then allocate the correct named resource later, when you have a…
-
moving multiple columns (awesome)
I don't know why I never tried this before but I aways move columns one at a time when arranging a sheet. Well I just stumbled into the fact that you can select a group of columns and move them together as a group (awesome!) Just sharing, ..... mike
