-
Summarise Tasks into single cell
Hi there Smartsheet Community! I have been a smartsheet user for a few years now but this is my first post with the community (so i'll try my very best to describe my issue) I use two different sheets for planning in my company, which is currently manually updated. I am hoping to link these sheets together so that…
-
Creating Report without Sharing Sheet - I need help!
I am trying to find a solution...I have tasks related to confidential legal matters that are in a smartsheet. As I am breaking those matters down into tasks within the smartsheet there are some tasks that are not confidential and I need my administrative assistant to complete them without being privy to the broader issue…
-
Blackout Date Template
Does anyone have a good blackout date template I could borrow? Something that is easy on the eye when glancing at it? Thanks...
-
Routine reminder
Hello, I am trying to set up a routine reminder to notify staff to submit a report. I would additionally like to have it notify other staff to follow up to collect reports once the due date passes. I set these up as two different workflows but if I can combine let me know. I am also trying to find a way to not have to…
-
Automated Update Request Form Changes
I have created an automated workflow, using the Request Update step. This automatically creates the form to send to the user to update. I would like to change the way the form appears and allow multiple line entries. When I go into Forms, that form is not there to update. How do I update the automatically generated form?…
-
AverageIF help
I need help with an AverageIF formula. SmartSheet support gave me this formula for help: =AVERAGEIF([Column6]1:[Column6]22, >0). Essentially, I want the formula to give me the average of the numbers in the Time-to-Fill (Working Days) column BUT ONLY if they list Human Resources in the Department column. I wrote this…
-
Creating a link that automates adding new cells into the sheet
On the current project I am working on, I am trying to use smartsheet to recreate an existing Microsoft Excel template that my company uses to collect data. At the bottom of the template, there is a cell that will create more cells at the bottom of the data set (ex. one region is working in 4 schools in quarter 1, but then…
-
Transfer Sheet and Report Ownership While Keeping in Same Folders
An employee retired without transferring his sheets and reports, that are in various workspaces and folders, to me. How do I keep the sheets and reports in the same workspace and folders while transferring ownership to me? I'm SysAdm and licensed user on Enterprise account.
-
How is the checkbox function recognised?
I'm trying to output the number of sick-days into a cell using the criteria 'email address' and checkbox ticked as i only want it to recognise the sickdays if checkbox is ticked. Don't really understand how the checkbox is recognized as I am getting a '#invalid operation' =SUMIFS([Is your absence related to a…
-
count an instructor only if last name is different
We send instructors to teach globally. I need to keep count of instructors on the field, quarterly. Sometimes 1 instructor goes to teach 2 courses. So the count would be 1 instructor, 2 courses. Sometimes 2 instructors go to teach 2 courses. So that count would be 2 instructors, 2 courses. This formula seems to work where…