What is wrong with this Smartsheet formula? Getting Unparseable. =SUMIFS([Car Count]1:[Car Count]39, [Expiration Date]1:[Expiration Date]39, ">=" & TODAY(), [Expiration Date]1:[Expiration Date]39, "<" & TODAY() + 365)
I wanted to know if it is possible to create a calendar view for a given individual assigned to multiple column of assigned data tasks? In the smartsheet list, I want all the dates captured into one line and all deliverables column assigned to a given individual. How do I go about this?
I have a tracker where I am tracking dates when tasks are closed, but I'm running into an issue where some items are being "reopened" for additional follow-up. What I want to do is know WHEN that happens (so I can track trends or culprits LOL). Is there a way to record a date when this happens? My record a date workflow is…
I currently have a line chart widget that tracks count of a value weekly. The only problem is that our week starts on Friday, ends on Thursday of the following week. I have set up helper columns with a formula =WEEKNUMBER([NEO date scheduled]@row) but on every Friday, i have to change =WEEKNUMBER([NEO date scheduled]@row)…
Hi All, I am trying to troubleshoot my workflow to see what I may be doing wrong. I setup this workflow to send a reminder and then check off a box in a column after it sends. This issue is the reminder is going out but the box is not getting checked off. Attached is a screenshot of how I have the workflow setup. The…
Hello! We have had a request update automation in our sheet for years. The idea is very basic, to assign a contact to a cell and they receive a request to update other cells on the same row. This has worked perfectly up until the evening of 4/15. After that, the automation has not been working correctly. In the below…
I am running a report from my sheet however the primary column shows up even though I did not select it and I cannot hide it. I don't want/need it in my report. I was wondering if there was a way to remove or prevent it. Thanks!
Hello, How can i set up a column to calculate how long it took to complete a task from the date it was assigned to date it got completed? I don't understand the dependencies in the project settings.
I am creating a form from my Smartsheet. I want to have multiple options with check boxes but have not been able to find out to add more than one check box.
Hi there, I'm receiving an error when trying to add a sheet into our teams channel. I have no issues connecting to smartsheet within teams and selecting my desired sheet to add, but when I select the publishing and access options, then click save, I immediately get an error. See attached screenshots (Pic 1 is selected…
How would one go about getting access to a sheet/form if the person that created it is no longer employed?
Hi there, I am hoping to find a way for our staff who submit information through form to receive an email confirmation without having to get a copy of the information they fill in the form. At the moment the only email option is to have them get a copy of their response to the form, but I don't want them to have a copy of…
How can I customise an update request in a workflow, so that the updater has fields that are required to be updated before submitted the update?
Help shape the future of Smartsheet. Share your ideas and feature requests.