-
Can we have chart in sheet like we do in excel
Hi There, Can we have chart in sheet like we do in excel I dont want dashboard I want the chart % to be in sheet column Thanks
-
Dropdown List in Single Cell in Smartsheet
Is there an option to make one cell in Smartsheet have a dropdown list?
-
Report Summary - New function isn't working
According to this https://help.smartsheet.com/articles/2482083-summarize-content-to-extract-key-information-with-report-builder I should be able to summarize my report based on ANY field. I am trying to summarize how many tasks an individual person has been assigned to. The help document says that a contact field should be…
-
Using IF with greater than or equal to a number
I want the "Complete" column to show "yes" if the total reviews is greater than or equal to 3. I cannot figure out what I did wrong with the formula above. Thanks!
-
Ignore blanks while detecting matching text across multiple columns
Hello! I am trying to write a formula for detecting ANY matches between "Affiliation" and "Affiliation 1," "Affiliation 2," or "Affiliation 3". If any of them match "Affiliation", then "conflict" is true. If false, it should say "none". However, if "Affiliation" is blank and matches another blank, it also outputs…
-
Column Number Function
Hi is there a function that can return the column number when given the column name? This would help when columns are added in sheets that have vlookups referencing them.
-
Record a Date automation keeps updating to today's date.
I am using the "Record a Date" function to identify an Approval Date when the status of a request changes to "Approved." The automation does record the date once the status is changed. However, once the date is recorded, the automation continually updates the date to the current date. For example: If a request was approved…
-
Date use with COUNTIFS formula (Non-Specific Date)
I have set up a summary grid pulling information from another Support calls grid so I can keep track of logged calls completed by members of my team. I am currently using the formula below to pull that information for one of the team and it works fine. =COUNTIFS({Support calls Range 1}, "Complete", {Support calls Range 2},…
-
Form not showing up in list of sheets- but link works
Hello, I created a form for people to confirm they've read my info. Sent the link to the form. The link works for me, I've received confirmation that I've used the form. But when I log into my account, the form does not show up on the list of sheets, nor is it located in the "manage forms" section. How is it possible that…
-
Why is the mobile app showing me a different form?
Hello everyone, I hope you are having a good Sunday afternoon, I created a form that works very well on computer. On the other hand, when I open the same form on the smartsheet application for a mobile phone, it seems that it does not take into account certain logic that I have programmed. Before opening a ticket with the…