-
Extend decimals in the Pivot App
PivotApp currently only extends two decimal points, so when calculating percentages, we only see the rounded whole number. Please extend to at least four decimal points so more specific data points can be collected. Current state .25 or 25%. Future state .2557 or 25.57%.
-
Formula question
Hello all! Can you please help in writing a formula in smartsheet that will give me column B against column C and column D? This is just a sample but it came from a large data set. so if COlumn B is 111-22-333, it is owned by Column A and described as column D.
-
How do I delete any and all alerts and reminders from being sent on a whole smartsheet?
email messages are being sent for some of the rows/tasks on a project smartsheet. I click on the row and select Automation / Manage Workflows but there are no workflows, yet emails are being generated to the people assigned the task/row.
-
Need to use Card View to view only the Filtered columns
Hello, I'm looking for a workaround/ solution to an issue I've run Card View. Question: Has anyone tried a successful work around to get rid of the extra columns in Card View on a filtered report? I thought about making an automation from each source sheet to "copy rows" for for each Department, but the cells aren't linked…
-
New Sheets defaulting to project view
Has anyone created a new sheet (grid view) in the past few days and had it default to a project schedule complete with status, start and end date, etc. filled out? I assume I've changed some setting in the background, but cannot figure out where. It's incredibly annoying and a time waste, since I'm not trying to create…
-
Mark Checkbox if Emails in both sheets are equal and response to Opt In is Yes
Needing to know if this is a possibility to link a sheet that is generated from Form responses to mark a checkbox in the destination sheet automatically. This is to be applied to the whole column. This way as form responses come in, it would ideally update the destination sheet. IF the Email on the Source Sheet is equal to…
-
Resource Management - Date View
Hi all! We used to have an option at the top of the Schedule View on Resource Management that allowed us to quickly jump from week to week/month to month (green box in screenshot). It now looks like we need to click the arrow (red box in screenshot) multiple times in order to scroll through all the dates. Is there a way to…
-
Sumifs- With a start and end date range Errors
I am struggling with this formula. My Syntax is correct, the lay of this formula works until I add my date range. I have tried having both my formula column and the referenced date column as date, dates restricted, as well as just Text/number. I have a years worth of data I want to calculate grand total of sheet, which is…
-
File Upload Form Element grayed out, how to fix?
I'm trying to adda a File Upload form element but the box is grayed out, is there a solution for this issue?
-
Pivot table only has 2 decimal places
I'm creating a pivot table using the Pivot App from a sheet (also tried from report with the same data, and neither resolves the issue), where the values are percentages that go out to 2 decimal places. (Ex. 95.25%) The pivot table is converting the values (whether I do sum or average) to a number and only two decimal…
