-
Sum(children()) with filter or in reports
Hi there, is it possible to get the sum or count of a filtered sheet or in a report? I want to know how many lines are filled with data. I use the count(children()) function. In one cell are the nicks of the employees (like "KOV, SEA, KEP ..."). Now I set a filter that only shows me lines where "KEP" is in this string. In…
-
Newest date in children input text
Hi everyone Is it possible to automatically input data from all children regarding newest date to parent? For example I have 10 children, with text and multiple dates in the same children row, I want it to automatically upon newest date in specified collumn in all children input the text in the text collumn from that…
-
Update email address for contacts does not update shared sheets automatically
Hello all, I have been in the process to update email address for some of my contacts due to the change of domains. However in doing this I realized that all my sheets shared with those specific contacts are not updated with the new information. Let's say that I have already shared or assigned tasks to these contacts. I…
-
Auto Archive Completed Tasks To Another Smartsheet
Have a smartsheet with about 6,000 rows of tasks with 38 users updating. Since Smartsheet becomes very slow with that number of rows. As tasks are completed we use the move row feature to archive. However we would like to automate this so that when a task is completed it auto archives to another sheet. We have read that…
-
Are points no longer tallying?
I seem to have remained stuck at the same point value after the community redesign? Is this accurate or am I missing something?
-
Top Row
I'm new here, but I have an odd problem with one of my sheets - the top row seems to be minimised, only half of the text is readable and I can't figure out how to fix it?
-
Double check my formula
This formula turns the Harvey Ball gray even when there is a blank child. What am I missing? =IF(COUNTIF(CHILDREN(), "Red") > 0, "Red", IF(COUNTIF(CHILDREN(), "Yellow") > 0, "Yellow", IF(COUNTIF(CHILDREN(), "Green") > 0, "Green", IF(COUNTIF(CHILDREN(), "Update") >= 1, "Update", IF(COUNTIF(CHILDREN(), "Gray") =…
-
Multi-Layer Gantt Chart
Hello, I'd like to create a Gantt chart which allows me to layer an original date range and an actual date range. This way, I would be able to show how a schedule has changed against an original base line. Ideally, i'd like to be able to see the original date as one color, and the actual date as a slightly different color,…
-
Changing Smartsheet layout and effect on Webforms
Hi, If I add new columns to an existing smartsheet (with webform), will I need to review/rebuild my webform, or will it still populate the correct columns? Thanks
-
create a gantt diagram (ressource/tasks)
Hi all, is it possible to display a gantt diagram, not in the way tasks and ressource assigned to but by ressources and tasks assigned to ? Thanks a lot
