-
Calendar View Expanding
I have a user in my organization that is not able to expand out hidden items in the calendar view. She has the drop down arrow located at the bottom righ-hand corner indicating that there are events that are not being shown; however, when she clicks on it, nothing happens. Has anyone had this happen before? Thank you!
-
Count entries in a range that has text and number+text entries
Im trying to count the number of times street avenue occurs in a column based on the range a user enters. I have tried using countifs >=starting range and less than ending range, but it only counts the number/text entries. Looking below if I did countifs({avenue},>=110, {avenue}<111) I only get 2 as the count, but I should…
-
How to automate monthly data from another sheet?
Hi all, Every month, we are required to display new data for review. The problem is that it has to be manually done. I have to login the 1st of the month into the data sheet, copy the data of information that we get from a master sheet, create a new column and paste it there which then is linked to a dashboard with a graph…
-
Moving Sheet Template with links to blueprint into another Workspaces
if you move a template from one workspace to another, would you lose the links associated to the blueprint?? I know you need to be an owner to be able to move the templates to another workspace but all the links associated to the data sheet fill in the blueprint, so if I move it to another workspace, then would I lose…
-
Workspace Columns
Is there a way to add a 5th column to the workspace? I need to be able to see who the last individual was that modified the sheet at a glance.
-
IF condition and a blank cell.
I need the formula to work when the cell its reading is blank. =IF(MONTH([Closing Date]@row) = 1, "January", IF(MONTH([Closing Date]@row) = 2, "February", IF(MONTH([Closing Date]@row) = 3, "March", IF(MONTH([Closing Date]@row) = 4, "April", IF(MONTH([Closing Date]@row) = 5, "May", IF(MONTH([Closing Date]@row) = 6, "June",…
-
How to combine multiple sheets with large volume of data
I have a large data set (9K rows + 250 columns) so it is broken up into multiple worksheets. Is there a way to combine? I have figured out how to build reports on multiple sheets, but not how to compile the results for a dashboard (ex: count how many records are across all sheets and have this on dashboard with a breakdown…
-
Alert on Attachment Upload
Is there any way to run an automation or an alert when a file is uploaded to a row? Is there any way to run an automation or alert when a row is missing an attachment? The only work around we've found so far is to put in a check box that must be checked when the file is uploaded, but we are hoping to automate that process…
-
Converting email from Text/number format to Contact List format
In a smartsheet, I have a Text/number field that has email in the format john_doe@companyname.com. When I change the format from Text/Number to Contact List, it does not change to Contact list format as John Doe <john_doe@companyname.com>, it leaves the name field blank and I have to add the name manually. Is there anyway…
-
Sum up workload for sum tasks
Hi there, we plan the workload for tasks in hours (not in % as Smartsheet wants us to do ;) ). How can I set up a formula for sum/parent tasks to calculate the total workload of subtasks? Do I need a helper colum? Do I have to put in a formula in every sum/parent task? Thanks, Markus