-
API CSV import to active SmartSheet
Hello, I have written a program that utilizes the API from smartsheets; for simplicity, it just takes data from a source and imports it to SmartSheets. Problem is, it can only import it on a new sheet, not an active sheet. I understand that there is a tool that was recently developed: Data…
-
New Format is less efficient--More Clicks to manage our work!
The new format that was introduced today is definitely not more efficient! In fact it's creating more work through extra clicks.
-
Count number of specific characters in a string
Hi! I'm trying to write a formula that will give me the level of an item in a Work Breakdown Structure (WBS). The formula needs to read the number of decimals in a string. For example: * 1 = 1 * 2.12 = 2 * 3.1.14 = 3 * 2.1.1.1 = 4 * 2.327.1 = 3 The FIND function seems to be heading down the right track (by selecting the…
-
Tabs No Longer Showing
Sometime last week I noticed my view in Smartsheet (using Chrome) no longer has the tabs at the top of all of the current open sheets. How can I get this view back? It was much more efficient than the pinning option we have now. Also, the recently reviewed Smartsheets would be great if it actually filled up that column but…
-
Calculating a percent
Hello, I am struggling to calculate the % complete based upon Target Savings / Realized Savings. I am trying to track the % complete of task based upon how much of our target savings we have realized. Any suggestions are appreciated. Thank so much, Katye
-
Percentage Complete Calculating Differently on 2 sheets
I have a smartsheet that is pushing data to another sheet. Percentages complete are part of the data that is being pushed. On the source smartsheet it shows 45% for a section. On the Target sheet it shows 63% complete for the sames rows. Can anyone explain why I am getting 2 different percentage completes calculated?
-
Counting and Dates
Hello, I have been trying to come up with a formula that works. I am trying to count all of the "request" I have through a certain date. The form that I am using to take requests and the sheet that I am tracking metrics are separate. =IF(AND({Intake}) > DATE(2018, 12, 1), {Intake} < DATE(2018, 12, 31)) This is what I am…
-
Counting cards according to their status
Hi. I have four projects, each assigned to a unit division. Each project has tasks in different implementation stages. By default, Smartsheet counts how many tasks are in each stage (column). I want to use that counting to display in a dashboard, so I can see the status of tasks implementation by unit division in a single…
-
COUNTIF Formula for when a cell contains a specific word/phrase?
I'm trying to create a formula that allows me to count the number of times the word "Postcard", for example, appears in a list in a column. I am referencing a column in another sheet to do so. However, nothing I've tried works. My instinct was to try =COUNTIF({2018 Open Enrollment Feedback Range 1}, "Postcard"). However,…