-
How can I compare two date columns in an automated workflow?
Hi! I want to create an automated workflow which copies rows where two date columns are not equal to another sheet, how can I do this?
-
Can I create a sheet from a report
I have a Budget report which I exported from Quickbooks to Excel and finally into Smartsheets. I need to generate a report or sheet which only captures certain items included in this PL and which then also calculates the total value of those items I choose. This is a report or sheet I want to generate quickly and easily…
-
How do I display row numbers on a report or dashboard?
I would like to display an incremental number for each row on a report I build for a dashboard. This report pulls in data from multiple sheets. I don't need the original row number from each sheet, I only need a series of numbers (i.e. 1,2,3,4,) to display per row. This should display the same regardless of the sort. The…
-
When people fill out my form, It isn't updating my Smartsheet.
When someone fills out my form, the form will say there is a submission, but a new row is not created on the smartsheet. How do I fix this?
-
When saving as new, I want to break links including sumifs but I'm having an issue
I have a sheet that's linked into a pivot sheet via a series of sumif cross sheet formulae. This sheet is looking into the pivot sheet at a point in time e.g. month of April YTD information, and the Pivot will update monthly as new data is uploaded to the source report (I will also need the new data but the historical data…
-
Why does cell history show user updating cell?
"View cell history" for certain cells in a collection of rows shows a user updating those cells at 8:43am. In Activity Monitor, I see that user's action at 8:43am was "Row hierarchy changes." So, she didn't actually update the cell contents, which is just a formula displaying red, green or yellow status if certain dates…
-
Customizing Confirmation Email
I have a smartsheet that has multiple workflows. One of the workflow goes external to the company (to my suppliers) asking for approval. This email involved supplier opening the file attached to the request, reviewing the data and then approving / rejecting the request. Other then this attachment, they do not have access…
-
New Admin Center - User Management
I like the update of the new "Admin Center" for controlling and editing users and groups, I accidentally clicked on the little graph with a down-arrow icon and got an email to download the user access data. It would be helpful to have a little tooltip for these, not only for the sake of our edification, but as part of the…
-
IF function conditioned on a PARENT
What is a formula to count in a sheet summary the number of completed CHILDREN tasks per PARENT. For example, I wanted to count the number of competed tasks that fall under the parent of Business Development. I tried the following formula, but it did not work...For more context: The column called "Task Name" lists tasks…
-
Chart budget vs actual
Hello, I have a sheet where I can see budget, actual and variance for my project budget. So column 1 is january budget, column 2 january actual and column 3 january variance, and so on. All I want to is to create a line-type chart for my dashboard where I can see the comparison between the budget and actual numbers for…
