Using Smartsheet
Post a question about using the core Smartsheet application: sheets, forms, reports, automation, dashboards, and more.
Discussion List
-
Can someone please help how this formula can work with the similar text?In Using Smartsheet=IF(OR(CONTAINS("Work", [ID]@row)), "Right" , IF(OR( CONTAINS("Worklife", [ID]@row)), "Wrong",""))
-
Card View LabelsIn Using SmartsheetIs there a way to show a field or custom value in the label of card view? For example, I have lanes based on assigned to->all good here and easy to do. What I want in addition is next to that name display # of hours assigned to that per…
-
User tried to add sheet owner as a Contact in a multi-select contact field, removes other contactsIn Using SmartsheetI created a form/sheet that has the entire team as dropdowns in a contact field. When a user tries to add my name, it removes all other contacts from the multi-select field. Why is this and is there a fix?
-
How can I ban or control indenting and outdenting?In Using SmartsheetHow can I stop users making a mess with indenting and outdenting? I am providing users with a template which contains some summary rows. I have formulae on these rows. They are: Level 0 - totals Level 1 - subtotals for tasks within that g…
-
Receive an emailed attachment on submission of form.In Using SmartsheetIm creating a shipping request sheet and have created a form so people can submit address details etc . Once submitted this will go to a department for approval. I would also like an attachment to be sent with the email . For example, the …
-
How can I make a pie chart that aggregates dropdown choices in a column?In Using SmartsheetI have survey results that I need to make into a chart - for example, let's say for a question where they rate something from 1-5. Ideally, in a pie chart, it would show that x% of respondents answered 4, x% of respondents answered 5, etc…
-
Reminder: Request to join Smartsheet AccountIn Using SmartsheetHi, I am the system admin of smartsheet in my organisation, using business plan account. I have invited some of my colleague as free collaborators to view the sheet. The free users know they only need to view and never request for licens…
-
How do I create an assignments summary sheet?In Using SmartsheetI'm working with a healthcare department, and our staff are assigned cases to contact trace. They contact the individual or facility, enter in the relevant info to a master sheet, take whatever notes they need, and then mark it as complete…
-
Issues with TODAY formulaIn Using SmartsheetI'm using this formula (=COUNTIFS({FINAL - Post Check Tracker Range 24}, "Outstanding", {Post Check) to count entries completed today from another sheet. The formula is pulling information from the automated "Created" c…
-
Combine Info from Multiple Projects to a Report, pull status from Report to Sumamry SheetIn Using SmartsheetFirst, forgive me if this is convoluted, I may be approaching this in entirely the wrong manner. I have a varying number of workspaces, one workspace for each project. The number of projects changes over time. I currently provide a "…
