-
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
-
Assign Tasks to people without they having to see everyone elses task
I have created one master sheet with ask entire list of task with assigned to column. I want to create either new sheets or reports what every person has their own task list and they cannot see other people's task. Is it possible. In their own report or sheet they should be able to comment and add details to the columns…
-
How do I update my function syntax to stop getting the #INVALID DATA TYPE error?
I'm working within a sheet and trying to calculate the number of days between two dates. Above is a picture of what I'm seeing and my syntax is below. =NETWORKDAYS([Start Date]@row, [Date Completed]@row) I've tried to add IFERROR in a couple places and it didn't help with anything unfortunately. My Task Duration is set as…
-
From Web Excel Query and Smartsheet Publish Link
Hello - This is a bit of an Excel/Smartsheet question in truth. We have some workflows that depend on the From Web data function in Excel (Data -> From Web). We have switched our publish link to only be accessible to people on our account (instead of being published publicly), and the workflow now fails. I believe this is…
-
Full Edit Functionality in WorkApps
I put all the files I needed in WorkApps for efficiency, however, it could have been more efficient if we allow full edit functionality, for example, add columns, cell links etc, that do not require editing your sheets, reports, and dashboard at the Smartsheet application. The intention is to save time and increase…
-
Why is there an edit limitation while you use WorkApps?
I put all the files I need into Workapps (sheets, report & dashboard), only to find out that not all the edit functions when you use right click are available. I was trying to cell link but only a hyperlink is available when you edit your sheets at Workapps. Thought it would more dynamic and efficient, but seems like I…
