-
How to count crosses and starts
Hello, I have a production chart where with times of 6am,9am,2pm,5pm,9pm,2am,4am. At any given time, under those boxes at any given time we can have a box labeled Start or Cross. I have created another sheet to track starts and crosses but how do I get it to automatically pull from my chart to the tracker? To clarify, if I…
-
Drop Downs
I'm using multiple dropdown columns on my smartsheet, most work, but a couple don't. When I try to click on the dropdown, nothing happens. Not sure why?
-
check duplicate row and keep only the last one
Hi guys, Hi have a sheet with an automatic import (using Data Uploader) For some reasons, sometimes I have two times the same row datas collected from my data sources. How can I use a formula to check if I have duplicate row and if I have duplicate row, only "keep" (or check a box for the row) the last import (I already…
-
Can I "count a specific person in an Assigned To column when there are multiple people in that cell?
I want to know how many tasks are assigned to a certain individual, but this individual is assigned to tasks that are also assigned to others as represented in the Assigned To column. The "Allow Multiple Contacts Per Cell" box checked. Is there a formula that will pull out only one of the names listed? i.e., 3 cells have…
-
Reports STILL not showing linked cells (grid) data
Is there an update on why reports are not showing cell data that is linked? Very frustrating trying to build a report and dashboard module.
-
Summing Durations Issue
Hello , I am looking to sum a durations column that has varied input including hours, days and weeks. However it sums the number instead of the indented values. Ex: 1h, 5d, 2w should sum up to*:151, but instead I get 8. Is there a way to convert all durations into hours and then sum? To make it more complicated I am using…
-
Can indented rows in Smartsheet show their parents in 10,000ft?
I am using 10,000ft to visualize my resource allocation. I am using a Smartsheet project plan do the actual allocation, and in this project plan I have "phases", "tasks" indented to those "phases" and "type of resource" indented to those "tasks." When I go to 10,000ft, however, in my schedule I only the resource and the…
-
Mindmap / Spider Web views of parent/child and relationship dependencies across worksheets
Hi Has anyone looked at or know of a way to create a more interactive dashboard of a mindmap / spider view of worksheet relationships and parent child dependencies within? I am using smartsheet to manage organisational OKR's and whilst I can create traditional grid/card and even dashboard views the OKR tools I am seeking…
-
Automatic date column completion when a comment is added or modified
Hello, I want to create an automatic workflow to get the last update date of the comment section in a date column. To do this, I created the attached workflow but it doesn't work. Could you please help me to fix it ? Regards, Souhaïl BOUDADI
-
Group Management: Download list of group members
Hi! I am a sys admin and manage groups for our account. I have to do an audit/update of a large Group in Group Management. I received a new csv master list of the group of members, including all who are already in the group, and those new members who will need to be added to the group. I think I have to compare who is in…
