-
Anyone using Jira tasks in Smartsheets currently here??
Anyone using Jira tasks in Smartsheets currently here or do you know anyone ?? Please share the best practices adopted by you
-
Children not displayed
I have a list of that will not open up today. There are 671 children and the "+" and "-" changes but the rows are not displayed. Help please! Rose
-
Unicode character to allow blank rows in forms
In the spirit of sharing, I thought I'd let you all in on the Arial Unicode Right-To-Left Mark character that can be used in forms to add blank row between Help Text and the form value. As per the image below: * begin by selecting and copying the U+200F character from the Arial set in the Windows Character Map application.…
-
Notification Dates
Is there a way to edit the dates for when to set a notification past 14 days? We are looking at a way that this can be edited when we need notice 3 weeks in advanced or any specific number of days.
-
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…
-
Adding rows and data types with C#
Hi Everyone, I am currently trying to integrated SharePoint data into smartsheet. However, I am struggling with data types and most of the cells do not take my values. I think I have no issue with certain type like TEXT_NUMBER or DURATION but for the other types I am stuck. Can someone show me an example of how to insert…
-
Countifs - with Hierarchy (Grandchild)
I am trying to write a formula to count the lowest level of "Completed" items. I have multiple Projects and different Status all on the same sheet. =COUNTIFS((CHILDREN[Variable Features/Tasks]:[Variable Features/Tasks]), Status:Status, "Complete", Project:Project, "Test") I'm not working in excel - I just wrote up the…
-
Web form and linking
Dear all, right now I am struggling a bit as I'd like to implement a web form that is forwarding information into a master table from which the new added row should be directly linked to further sheets to be evaluated and qualified. I had a look in former threads and tried the reporting function, but this won't let me…
-
How to make formulas work on top of a sheet if new entries are coming on the bottom of the sheet via
Hi All I am really stuck with this as I need to amend my fomulas manually every time I have a new entry. Whenever there is a new entry ( via Web-form) I need to change the formula to include the new row instead of helping me with automation it has created extra work for me. Did any of you faced a similar problem? What…
-
Filters no longer summarize counts
Before today's update to the new improved Smartsheet, when you used a filter it would give you the count of items it filtered on. Now it does not do this. You have to select all elements in a column to see how many there are. Why did this change? Is there another way to find the total number of filtered elements? This is…