-
WorkApps Attachments Disabled
Has anyone seen this in WorkApps? Anyone know what's going on?
-
Published Sheet - Users Unable to add Attachments
I have a sheet for which I've provided a publish link to many unlicensed users. They use the sheet to attach files to rows. This has been working as expected for multiple years previously, but today, we've discovered it will not allow them to attach files to rows and they're met with the message "This action has been…
-
Finding Next Closest Date of Children
Ok hive mind - I haven't been able to talk this formula out with someone yet, so I am looking for a little help. I have the formula that will fill out the children of my FINAL DATE column, but to fill out the parent row, I want my formula to look at the children of the NON REFUNDABLE DEPOSIT column, and tell me what is the…
-
Project Cutover Planning
I have been working to transition my Excel based cutover plan to Smartsheet. I have read the posts about the challenges with Date and Time and having the ability to calculate duration with these challenges. Has anyone identified a truly viable option to track tasks at the minute, hour and day level for both child and…
-
HELP! Move Row Automation
I created a "move row to another sheet" automation where the trigger is when rows are changed and ACTIVE / INACTIVE status changes to INACTIVE. When I changed the status in one row, the automation was triggered and now all of my rows are gone, and they are not on the destination sheet either. Where is my data? There is no…
-
IF AND OR not working properly, last IF not triggering anything
Please help me figure out why this is not working: =IF([% Complete]@row = 1, "Completed", IF(AND([Start Date]@row <= TODAY(60), [% Complete]@row = 0), "Not Started", IF(AND(NOT(ISBLANK([Start Date]@row )), NOT(ISBLANK([% Complete]@row ))), "In Progress", IF(AND([Start Date]@row >= TODAY(61), [% Complete]@row = 0),…
-
Best Practice Inquiry
Good morning, We have an expense report that I pull from our system 2 times a month and put into Smartsheet. I have about 100 Department IDs I share it to split between different 10 bureaus and 4 centers. I am trying to find a good way of splitting up the information. Currently I have 10 grids for the different bureaus…
-
Freeze Rows...
you can freeze columns, but not rows, which makes literally 0 sense. It should be a basic function, have seen people talk about this years ago and its still not a functionality…
-
find manually entered duplicate lines
I have a sheet that contains practice-name, practice-seq,and coach-id. I have somehow added multiple exact duplicates. there are 8500 entries so its hard to find them….is there a report I can run to just show eact dups?
-
Deleted so much data
Good Morning, I was working too early and after vacation and deleted some needed information from a report and it changes all my workbooks. I did the download for the history however it doesn't show me the data that was in the cells. Is there any way to get that information?