-
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.
-
Tags (possible feature request)
Hi, is there any way to tag rows? I can use a dropdown list, but that only allows for one "tag" per row. I could also use a comma-seperated list, but without autocomplete and/or tag-management it's a very error-prone approach. All feedback is much appreciated!
-
Can you do if this then that for auto entry from drop down list
I want a column to chnge its value from a drop down list when a criteria is met. What I am after is a column that is titled "ready for invoice" and is a check box. I have another column named "currently assigned to"that shows the seperate departments on an account and it reflects which department is resposible for the…
-
I need to restrict access to a web form to only a specific group, can I do that?
I am using Smartsheet as a project list and a web form as a work request system. I need to restrict access to the web form so only spefic people can file a request. is that possible?
-
Modifying RYG Symbols with Dates and Status
We are trying to create a formula on the Schedule field that will change color to Red, Green or Yellow based on Multiple day and Status selection. For example: If Status is In Progress and End Date is > Today and R - Date is Empty then is Green. IF Status is In Progress and End Date is < Today and R - Date is Empty or a…
-
Folder in Attachments area
For our particular needs we find ourselves needing to separate attachments into categories - new or previously used. Is there an enhancement on the horizon that would allow the creation of folders, or an option similar? Blessings, Loann
-
Excluding cells from COLLECT based on value
Hi All, I am trying to write a COLLECT which excludes results based on the value of a cell, similar to how NOT(ISBLANK(@cell)) works. Below is a formula I have made which works, but I was hoping there was a more succinct way to achieve the same result =JOIN(IF([Audio Language]153 <> "English", COLLECT([Audio…
-
Web form submitted child rows - how to sort them into place?
Good afternoon, I have a sheet where we are tracking time allocated to various projects. Each web-form submitted project is then given a parent/child relationship with the child row being the submitted info and the parent being the summary view of all the children by the same project name. However, when I try to sort new…
-
CountIFs Formula Help to Show Number of Resource Open, Closed and Overdue Tasks Across Multiple Acti
I need a COUNTIFS formula (I think this is the best option based on research) that calculates all of my technical resources task status for all of the projects. An example is below. I have 4 current projects and 7 resources. Please see the screenshot for an idea of what I'm trying to accomplish on a Metrics sheet that…
-
eliminate INVALID DATA TYPE when using a IF statement to display the month
I am using an IF statement to display the month but when I don't have a date the column is displaying #INVALID DATA TYPE. I understand why this is happening but I don't know if I can also incorporate the use of an IFERROR statement nested. What is the correct way to eliminate the #INVALID DATA TYPE? Here is my IF Statement…