-
Can index+match be used to add values together?
I'm in the process of creating a series of sheets to track weights submitted by a variety of people. The people are going to be categorized by 'team', and I already have an index+match formula that takes their submissions and automatically organizes them to like a main row per person, each value going into the column for…
-
Identifying who is double booked in a meeting at a specific time and date
So I am trying to identify how to see who is duplicated and double booked at specific meeting slots. In the first two rows, you can see the duplicate flag shows up because it is the same exact people in the same order, but when i add "Jordan" on the 3rd row its not showing people are duplicate. Is there a way to show who…
-
Is there a way to optimize drop down menus?
hello i am trying to have certain values only show when someone chooses one value. here's an example: Entity 1 Entity 2 Entity 3 Now based on those three entity there would be a seperate drop down menu with 10 items: Item 1 item 2 item 3 item 4 Ext... But if i choose entity 1 then only item 2 and 7 show but if i choose…
-
Can a Display Message be Created When a Report Has No Data to Report on for the Week?
Hello, I created a Report regarding issues that need to be escalated to leadership. I was able to link the report up to our folder and get data to run through the report to show what I needs to be reported on. Since there are weeks when issues will not require escalation and the report appears blank, I am looking to have a…
-
Add Comment Section to a form
Hello, Is there a way to add the comments section to a form? Or a formula to move / copy text from a comments column into the comments section? Thanks! Matt L.
-
How can I sum all the values of a column of "hours"?
hi everyone, I'd a issue with "time sum" that i need to converting to decimal after sum as you can see in the picture below. Is possible do a time sum without converting to decimal? @Paul Newcome do u mind help me with this quest? i really appreciate any help.
-
Reports-Calendar View- Tasks from various sheets intermingled, how to fix?
Hello, I created a report to pull various training calendars into a master report. I have New Hire classes vs Cross Training classes color coded from Conditional Formatting. When I look at the Calendar View of the Report, notice how some of the blue colored tasks are falling under the green colored tasks. How can I keep…
-
Is it possible to reset only a part of the baseline date during the project ?
Regarding the start date /end date baseline function, I'm wondering if it is possible to reset the baseline date just for a part of my planning. For example, if I plan my baseline at the start of my project for every task and I activated the baseline function, and in the realization phase, the baseline of only one task…
-
Smartsheet automatically switching from Browser version to Desktop App load screen
Hi All, I previously had the desktop app installed on my PC but chose to uninstall it as I prefer to work with the browser version (I work with multiple monitors and the Desktop app does not support that). For no apparent reason, yesterday, while I was actively working in the browser version - the screen randomly…
-
Show week commence date rather than actual date
Hi, Can I please ask if it is possible to show the week commence date of a date input (e.g. w/c 20th Feb) rather than 24th Feb 2023 as the specific date for example? Thanks, Sin Nee
