-
Question about cell linking and automation
Hello, I have recently been put in charge of several sheets that were managed by someone no longer on our team. I have experiencing an issue with one of the sheets adding in data and I am not sure where it is coming from. The way the sheet that I am having issues with works is that it pull in a Transaction Number and then…
-
Duplicate values
Hi, I need a formula that removes duplicate data. The unique identifier would be email addresses. I read the best way to do this is to add a checkbox column for duplicates but I can't figure out the formula to automatically check the box if the email address already exists in the sheet. Please help!
-
How to view your roadmap in Smartsheet
Hi All, I have just uploaded the Agile product roadmap template from smartsheet to create my roadmap in smartsheet account. After creation, I have not been able to visualise the end product as a roadmap (see image attached). Do i need to change my setting in smartsheet to view my roadmap? I can only see it as the Gantt…
-
Form fields and contact lists
This discussion was created from comments split from: Confused about Contact List functionality ... Best practices?.
-
Flourish Charts
Hello! I discovered Flourish which is an online platform that allows you to build beautiful charts for FREE. Once published, I can pick up a URL, script, or iframe code to use elsewhere. However, when I drop the code into my smartsheet dashboard as web content, it says "We can't find any embeddable content from this link."…
-
Report that groups one criteria and counts another
I have a smartsheet where each row represents a piece of equipment (there are hundreds). Each of these items is serviced by a particular supplier, so each row needs to be reviewed every year for a service contract renewal. When each row is reviewed that row is marked "Complete". When all of the rows have been marked…
-
Automatically create widget in a dashboard but with a certain widget behavior
If a new project is created in our Smartsheet, Control Center creates a dashboard automatically. Is it possible that Control Center creates an Image Widget with the Widget Behaviour where another sheet or form is linked? At the moment Control Center just creates Quicklinks but we want to realise that with buttons on which…
-
How to get access to Document Builder
Document Builder is not listed under the [File] menu
-
How Can I Pull only row data based on a specific cell in the row meeting certain conditions
In Excel I am able to use the below formula to pull row information into another sheet so that the only rows that are pulled meet the criteria of 1 conditon. =IFERROR(INDEX('On Rent'!$A:$A,SMALL(IF(AM$1='On Rent'!$B:$B,ROW('On Rent'!$A:$A)-MIN(ROW('On Rent'!$B:$B))+1,""), ROW()-1)),"") I am looking for a way to do this in…
-
how to do a shift planning with smartsheet?
Hello, who has experience in the implementation of a shift planning and possibly a template or tips for me? The requirements: - there are early and late shifts - in each shift customer service, phone service, flexible service (so 6 shifts per day) - Employees can schedule their shifts themselves, on a daily basis or over a…
