-
Column Titles Appearing in Metric Widgets
I was recently building a dashboard and found that column titles were appearing in the metric widgets I was creating. Usually this widget would never such column titles. It was whatever was selected in the reference sheet. Does anyone know how to fix this? I do not want column titles showing up in these widgets. Example…
-
Inventory Formula Question
I am trying to keep track of items we have to give out to community members. Mostly I am just making sure I know when I'm getting low on a certain item. I made two sheets, one with the name of each unique item and one with more details that allows me to keep track of the person and date the item was given. Those details…
-
Column functionality breaks when copying sheet
I have a template that I created to use for several projects within my org. When I create a new sheet from this template my Duration and % complete columns completely break and do not work anymore. I have removed and recreated the columns to see if this will rectify the issue and it does not. No matter what I do I cannot…
-
smartsheet API key is not able to fetch data from the smartsheet having MFA.
I am not able to fetch data from the smartsheet using API key which is having MFA. I am getting an error - "This action is restricted by an MFA Policy. Please reach out to the workspace admin for any questions.". How I can resolve this issue?
-
What licensing is required for collaborators, commenters etc please?
Hi, I have searched but can't find a definitive answer. If I create a project plan in Smartsheet and want people to comment, update or collaborate in general, which of those need a paid license please? To clarify, in this scenario the creator of the plan would have a business license. Many thanks.
-
I need to calculate % Complete
Hi, I am trying to calculate % complete with an IF formula because if it is marked complete I want it to say 100% and the current formula is tell me it is 3,098% complete because start and end date are in the past. Old formula: =(TODAY() - [Start Date]@row) / ([End Date]@row - [Start Date]@row) What I am trying to write…
-
DataTable Connection fails to transfer records when filter conditions change due to time passing
Hello, Some or all DataTable Connections do not automatically transfer data to the destination sheet under this condition: Filter: <Field name> is greater than <#> days from today Today the filter shows no result The next day, the sheet shows no data but the filter shows there should records transferring. If you manually…
-
Why is Dynamic View allowing me to build logic based off one set of dropdown values but not another?
I have a Dynamic View built from a report of multiple sheets. I am able to build logic in the DV based off a set of dropdown fields from one set of the sheets, as shown here: But when I try to do the same for another set of the sheets in the report, which has dropdown fields set up exactly the same way, there are no values…
-
Help with COUNTIFS formula
Hello all, I am looking for some assistance with a COUNTIFS formula. I have two columns of large data sets (staff ID numbers), one outdated and a new one representative of the current organization. My goal is to cross reference the two and see which IDs appear in both lists and which do not. I originally started playing…
-
Form Confirmation Options
I have created a purchase order sheet and form which auto generates a number each time. How do I reference this number to pull it through into the form completion confirmation message and/or email?