-
Automation, Reports and Projects
Hello, I'm trying to find a way to automate my Reports. I want to create a Report that uses an entire folder under Data. So that when I add a new sheet to that Folder the Report automatically updates and I don't have to modify the Report after every new sheet. Another automation I would like to do is create a site…
-
Ability to Adjust Axis Maximum
Hello, I'm opening a new discussion since the old version hasn't been responded to in some time. Stacked graphs are for some reason adding cushion on the ends. Is there no way to top these out at a certain number or percentage? In my case, I'd like to stop the percentage at 100%. Can we at least know if this is a priority,…
-
If Then Formulas
Hi, Is there a way to do an If/Then formula for obtaining a count if a certain word is typed in a cell so that the count automatically adds one for each time the word is entered? Thank you, Crystal
-
Primary Column Being Renamed is Annoying
I don't see the value in having the primary column being reset to "Primary Column" each time a report is created. I have to rename it to the same name as I have on my sheet. If this is so important, at least allow it to default and then click a check-box if you don't want it to default.
-
Error Message on Sub Tasks
Hi I created a bunch of sub-tasks and when I tag people in the comments and they get the email, when they click on "open in smartsheets", they get this error: "This card is not visible in card view because it is empty" Any idea what is causing this? Thanks!
-
How to display source sheet row number in a report?
In the available columns to display in a report, there is no option to show the row number of the record from the source sheet. Is there any alternative way to accomplish this? If not, can Smartsheet team please add this to the feature enhancements? Use case: I am displaying several tasks from a project plan that are…
-
Subtracting dates
I have an excel sheet that subtracts dates. The formula is as follows: =IF(P4="","",NETWORKDAYS(P4,Q4)-SIGN(NETWORKDAYS(P4,Q4))) This formula works. When I use it in Smartsheets, the formula is as follows. =IF([POC Date (Planned)]3="","",NETWORKDAYS([POC Date (Planned)]3,[Actual/Pending Date]3-SIGN(NETWORKDAYS([POC Date…
-
Question: Can you identify the worksheet behind a form?
The subject really says it all. I know I can go into a worksheet and identify the forms created for it, but can I do the reverse or do I simply have to check every worksheet until I find it?
-
Data Values Not Scaling
Can't figure out what I'm doing wrong. The horizontal axis won't let me scale to data values - option is grayed out so all the values are pushed to the top. In the first column the 86 should be in the blue, the 7 is for the red and the 30 should be in the orange. The vertical axis allows for scaling but it doesn't do…
-
create workflow for "task due in 3 days"
Hi all, I would like to create a workflow to send out reminders to assigned persons of tasks (cards) 3 days before the task is due. I set-up the attached workflow but at the moment it's sending reminders on the exact due date and not 3 days before. Would be happy to get your advise. Thanks so much! I'm using smart sheet…
