-
Move row to another sheet not working
Hi all, has anyone else experienced issues when moving rows to another sheet? I've got two colleagues, one of whom is actually owner of both - original sheet and destination sheet. When they try to move the row from one sheet to another, it just doesn't work. I mean, it does, as the row appears in the destination sheet,…
-
Trying to record time between changes in specific contact names
I am trying to record the response times of two individuals (A and B) when they receive notice of their name within a contact column (start time) and when they can remove their name from that column (end time). Note: there are dozens of other names in these sheets, but we are only focused on A and B. My thought is to…
-
Find the latest time entry and send a reminder if theres no entries in the future
Hi. I have built a form for our HR department to log their whereabouts for the following week. The team also receive an automated reminder every Wednesday to submit 5 entries (one row = 1 day) for each day of the following week. They simply advance the date field and select their whereabouts for each day. Although this is…
-
formula for past date
Is it possible to use the same formula but different length of time in the past? IF(AND([Quote]@row <> "Completed", [Date Sent]@row <= TODAY(5)), "Green", IF(AND([Quote]@row <> "Completed", [Date Sent]@row <= TODAY(10)), "Yellow", "Red")))) If today is 04.15.2024 and I need the symbol to change color as days past...…
-
Moving from Asana to Smartsheet
Can anyone share their experience in moving from Asana to Smartsheet? I'm looking for examples / visuals of what things looking like in Asana vs what they can become in Smartsheet. I've tried googling & looking on YouTube, but really only finding things about integrations between the two tools. Thanks!!
-
Dark Mode for Desktop App
I'm so pleased to see the release of the Desktop App. Such a key feature, so well done. It would be great to have dark mode included in the app.
-
Calendar View
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?
-
Record a date when a status changes from closed to open
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…
-
Department Helper Column Rollup Multi Select
The goal here is to create a helper column that with a formula will grab the department information from each task row, and then roll that up into the parent phase and project rows. However sometimes there is a department in the parent rows that are not in the task rows. So I need to be able to grab information from not…
-
Is there an easier way to add a filter with days instead of dates?
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)…