-
Formula help - due dates falling on weekends
I've got formulas in my sheet that calculate due dates that fall on weekends, and I've used conditional formatting to highlight those dates to alert me to those dates that are on Saturdays and Sundays. Now, I want to move those dates to the Monday next. Is there a way to automate that? Ultimately, I need the best way to…
-
Capturing Date of Transaction
Greetings, I would like to capture and freeze the date a drop-down column gets changed to "Picked Up by Customer". I tried modified date but that field gets changed too often to accurately reflect the state. Essentially, I want to know how many widgets were issued by date they were issued without looking at each cell's…
-
creating a form but not appearing in the Preview as a full form
I am a new user to smart sheet and I am working on creating a form.The problem that I am having is that all of the data for the forms are in there place but they are not appearing on forms when I do a preview of the form.
-
@ mentions not working
I am not receiving @ mention in comments even though my Notifications>Personal Settings are all checked. Other users are receiving them fine. My email appears in the dropdown as sheet collaborator. I am the owner of all the sheets. Anybody have any ideas?
-
Gmail add on issues (Chrome)
We are heavy users of this feature, and today it is not working. When you select an existing task or try to add a new task from an email, the circle will spin for a few seconds and then stop with no action having taken place. We've rebooted to no avail. Is this a known issue and is there an ETA for a fix?
-
Functions for predecessors
Are there Smartsheet functions for enumerating the predecessors of a row? I've been prototyping SmartSheets for managing a pretty sizeable research project (multiple FTEs over several years), potentially replacing Asana for group project management. The reporting is nice, as is the combination of spreadsheet, gantt, card,…
-
Excel Live Data Connector - Partial Results Returned
Hi, On Smartsheet the report returns all rows. When I export to excel it returns all rows. When I run the connector in Excel, it excludes some rows. It appears that the rows being excluded have a Text/Number value in column X i.e. D21, whereas the ones being returned just contain a number in column X i.e. 1901 - so I…
-
Enhancement Request: Auto-Refresh Functionality
I would like to request the addition of an auto-refresh feature within Smartsheet. I use one worksheet most of the day and I have to manually refresh the worklist several times each hour. It would be great if the auto-refresh feature could trigger anytime someone performed a change but I would settle for an auto-refresh…
-
Cloning a column within a sheet
Has the cloning of a column within the same sheet feature been developed? I saw the discussion back in 2016. Thanks Christi
-
Tried to edit my profile....
Profiles won't save if your department or position don't gel with some (I'm guessing?) pre-approved (somewhere) responses. So I did all the work of creating a profile, got a red x when saving and nothing saved. So I have no profile data. Also, the type on your site breaks words up all over the place so you may need to…
