-
Which is better in this case = Nested IF statement or using two formulas related to other columns
Hi, In the spirit of efficiency of memory usage, I want to figure out which methodology would be better: In either case, A/B are columnsย used to toggle several sheet functions as they relate to the heirarchy level the row is. * Use a nested IF statement: =IF(A@row = 0, SUM(CHILDREN()), IF(B@row=0,ย INDEX({REFย Share},โฆ
-
External Users and Security Access to Internal sheets
Can external users view internal sheets? Say someone outside our organization submits their bid, they get a notice that their bid was rejected and it gives them the link to our internal sheet. (see sample) I have only tested this using my own email address, so maybe they canโt see our sheet after all? If not the caseย howโฆ
-
Power BI
Has anyone used Power BI with Smartsheet? I do a lot of things in Smartsheet, and we have another department doing things in Power BI. I see articles in Smartsheet about Power BI, but not sure what that means or if I have opportunities I should be investigating.
-
Alerts
Hi, I am new to Smartsheet - early indication is it is an excellent piece of software and will help me enormously. I just cant seem to find a way of alerting the assigned to person (of the following task) once the previous task has been marked as complete. I would have thought this was quite a common task but cannot seeโฆ
-
Card View Stacked?
Hello, I understand why card view runs left to right. We are using card view to plan the layout of a 100 page magazine so we have 50 lanes. But there is only ever 2 tasks/cards per lane. Is it possible to stack the card view so we can see more lanes to view as visually this would be easier for us to manage this process?โฆ
-
Hyperlink in a value cell with formulas
Hi, I have a hyperlink question and wonder ifย someone can help me out.... I have a cell with values auto calculated by a formula to show the numberย ofย taskย done. In this cell, I would like to addย a hyperlink to a report so when Iย click the number Iย can see details in the report. However, it seems formula and hyperlinkโฆ
-
IF command and Date
Hi, I have 2 columns: Next Audit Due Date and Status If the date in โNext Audit Due Dateโ column is greater than the current date, I would like the โStatusโ column to fill in green and return value of On Track. If the date in โNext Audit Due Dateโ column is less than the current date, I would like the โStatusโ column toโฆ
-
Conditional formatting based on time from today
I want to create conditional formatting rules on a Date column and cannot figure out how to enter Today in the criteria Example: Select column = EOL Date is < TODAY = Red is between TODAY() and TODAY() + 180 = Yellow is > TODAY() + 181 = Green I can do it in Excel just fine but when i enter TODAY() in the criteria it saysโฆ
-
forms and cell linking to a secondary sheet
Hello I have created a Time sheet form that i sent out to 11 employees to gather all the daily info. This form fills in the Time sheet Smartsheet. We want to keep the Time sheet Smartsheet as a master sheet and strictly for data collection so that no one messes around with it and looses anyones time. Ive been trying toโฆ
-
Trying to Auto-update due dates based on actual completion date
Hi, I am new to smartsheetย and I am finding it very useful; except that I can't figure out how to auto-update completion dates. For example, when I plan out my project, I put start dates, duration, predecessors and who it's assigned to so I know when the project should be done. Building a house may require someone to buildโฆ
