-
Nested CountIf statement help needed
Hi, I need to create a formula where if a box is checked in one column, a figure in another column gets included in a sum in another cell at the bottom of the column with the numeric value. This is what I've got, but I'm getting error messages: =COUNTIF(QTR:QTR, "True", SUM(Blackline:Blackline)) I'm not sure exactly what…
-
Sharing Question -
A workspace was shared with me, and I was made an editor who can share. For a specific SmartSheet in a subfolder underneath that workspace - how do I request to the owner that I want to be an admin of that SmartSheet in order to set up conditional formatting, send automatic alerts, etc.? I do not see any option of making a…
-
Report Builder
Hi Are there any written instructions I can refer to in order to create a smart sheet report that I can then build into a chart? I have tried to create a chart from a dashboard widget and I am getting an error telling me I can only use numeric data Is this correct? Thanks Tracey
-
Conditional Alert enhancement status and issue with work around for alerts on incomplete tasks only
Any update on the functionality for the "Reminders" in "Alerts and Actions" to be conditional to eliminate for example tasks based on a completion condition? I used the work around proposed previously in this forum (see below suggested by @Mike Wilday) , but found this to have following limitation: Since you are using a…
-
Keeping Parent Card / Subtask relationship when moving card to another sheet.
Hello everyone. I was wondering if there is a way to keep the relationship between a parent card and its subtask intact when moving a sub-task between sheets. In our case this would be various departments who are assigned a sub-task then the card is moved to that departments board. When complete, the department would move…
-
Need for darker lines and dates on printed calendars
I export my shipping dates to a sheet that presents the data as a calendar that is printed and posted for our shipping packers and loaders. This is a great tool for allowing those on the team who are not on the computer to plan their workflow. The default color for the calendar grid as well as month and date labels is…
-
Smart Sheet app for iMac, MacBook etc
Are you going to create an application to be bought on App Store ?
-
if and formula help required
Hi there, i have the following formula that i cant get to work. basically, i am raising a flag if a job is at one of multiple defined stages and withing a specific timeframe. its the multiple stages bit that i am stuck with. current formula as follows =IF(AND($[Cust Requested Date]$1 + $[Column54]$9 > [Cust Requested…
-
Production Data Report
I am looking for help on setting up a dashboard of sorts to summarize monthly production data. What I have now in excel is that I can select a month from a drop down menu, and then the data fills into several tables I have made based on the selected month. Is there a way to have a similar setup within smart sheets? I…
-
automated updating sheet with xls file
Is there any chance to update data on the sheet with new xls without importing it once again ?